{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Simulador","SIMULADOR_","Simulador DATOS","Hoja1","LEYENDA"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":3,"defined_names":26,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Simulador","index":0,"n_rows":27,"n_cols":17,"rows_kept":27,"cut":false,"hidden":true,"merged":[[18,16,18,17],[18,5,18,6],[18,8,18,9],[18,10,18,11],[18,12,18,13],[18,14,18,15]]}
[]
[]
[]
[null,"Input",null,null,"Output"]
[null,"PRODUCTO","Prestamo Personal",null,null,null,null,null,"51.03% TCEA máxima calculada considerando un monto de S/5000.00 a un plazo de 12 meses y cuotas mensuales de hasta S/517.29. Total de interés mínimo S/1,177.36 calculado considerando el rango de tasas de interés aplicable, conforme al tarifario vigente.\n"]
[null,"TIPO DE SEGURO","3. Seguro de Desgravamen con Devolución"]
[null,"PLAZO (MESES)",12,null,"SEGURO DE DESGRAVAMEN"]
[null,"MONTO OFERTA",10000,null,"CUOTA*(S/)"]
[]
[null,"FECHA DE DESEMBOLSO","2024-10-24"]
[null,"FECHA DE PAGO",24]
[null,"PERIODO DE GRACIA",0]
[null,"TEA",0.15]
[]
[null,"SEGURO",{"$f":"+IF(C6=\"1. Sin Seguro de Desgravamen\",0,IF(C6=\"2. Seguro de Desgravamen Tradicional\",0.075%,0.085%))","v":8.5000000000000006E-4},null,null,{"$f":"+EOMONTH(C10,0)","v":"2024-10-31"},{"$f":"+EOMONTH(C10,0)+C11","v":"2024-11-24"}]
[null,"TED",{"$f":"+(1+C13)^(1/360)-1","v":3.883029878035682E-4},null,null,null,{"$f":"+G15-F15","v":24}]
[]
[]
[null,null,null,null,"N°","Fecha de Vencimiento",null,"N° días","Capital",null,"Seguro de Desgravamen",null,"Amortización",null,"Interés",null,"Cuota"]
[null,null,null,null,1]
[null,null,null,null,{"$f":"+E20+1","v":2}]
[null,null,null,null,3]
[null,null,null,null,4]
[null,null,null,null,null,null,{"$f":"+EOMONTH(C10,0)+C11","v":"2024-11-24"}]
[null,null,null,null,"N° ","inicio","fin","N° Días","Capital","Seguro","PP","EECC","Amortización","Interés","Cuota"]
[null,null,null,null,1,{"$f":"+C10","v":"2024-10-24"},{"$f":"+IF((EOMONTH(C10,0)+C11)-C10<30,EOMONTH(C10,1)+C11,EOMONTH(C10,0)+C11)","v":"2024-11-24"},{"$f":"IFERROR(G26-F26,\"\")","v":31},{"$f":"+C8","v":10000},{"$f":"+I26*C15","v":8.5},{"$f":"IF(E26<=$G$30,IF($G$8=\"Préstamo Efectivo\",5,IF($G$8=\"Préstamo Senior\",0,IF($G$8=\"Consolidación de Deuda\",0))),\"\")","v":""},null,{"$f":"IF(E26<=$G$30,O26-N26-SUM(J26:L26),\"\")","v":""},{"$f":"IF(E26<=$G$30,I26*((1+$AB$2)^H26-1),\"\")","v":""},{"$f":"IF(E26<=$G$30,$AN$5+SUM(J26:L26),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(E27<=$C$7,G26,\"\")","v":"2024-11-24"}]

{"sheet":"SIMULADOR_","index":1,"n_rows":113,"n_cols":15,"rows_kept":113,"cut":false,"hidden":false,"merged":[[48,4,48,16],[46,4,47,16],[34,4,34,5],[40,4,41,16],[42,4,43,16],[38,4,39,16],[45,4,45,16],[108,14,108,15],[109,14,109,15],[71,14,71,15],[72,14,72,15],[66,14,66,15],[67,14,67,15],[95,11,95,12],[96,11,96,12],[97,11,97,12],[98,11,98,12],[89,11,89,12],[90,11,90,12],[91,11,91,12],[92,11,92,12],[93,11,93,12],[71,11,71,12],[72,11,72,12],[93,14,93,15],[94,14,94,15],[95,14,95,15],[96,14,96,15],[97,14,97,15],[89,14,89,15],[90,14,90,15],[91,14,91,15],[92,14,92,15],[85,14,85,15],[86,14,86,15],[87,14,87,15],[80,14,80,15],[74,14,74,15],[75,14,75,15],[76,14,76,15],[77,14,77,15],[88,14,88,15],[112,14,112,15],[103,14,103,15],[104,14,104,15],[105,14,105,15],[106,14,106,15],[107,14,107,15],[98,14,98,15],[99,14,99,15],[100,14,100,15],[101,14,101,15],[102,14,102,15],[111,14,111,15],[110,14,110,15],[73,11,73,12],[84,11,84,12],[85,11,85,12],[81,14,81,15],[82,14,82,15],[73,14,73,15],[111,11,111,12],[87,11,87,12],[88,11,88,12],[79,11,79,12],[80,11,80,12],[81,11,81,12],[82,11,82,12],[83,11,83,12],[76,11,76,12],[77,11,77,12],[78,11,78,12],[78,14,78,15],[79,14,79,15],[109,11,109,12],[110,11,110,12],[94,11,94,12],[83,14,83,15],[84,14,84,15],[112,11,112,12],[51,14,51,15],[52,14,52,15],[53,14,53,15],[54,14,54,15],[55,14,55,15],[56,14,56,15],[57,14,57,15],[58,14,58,15],[59,14,59,15],[60,14,60,15],[61,14,61,15],[62,14,62,15],[104,11,104,12],[105,11,105,12],[106,11,106,12],[107,11,107,12],[108,11,108,12],[99,11,99,12],[100,11,100,12],[101,11,101,12],[102,11,102,12],[103,11,103,12],[86,11,86,12],[102,9,102,10],[103,9,103,10],[104,9,104,10],[95,9,95,10],[96,9,96,10],[97,9,97,10],[98,9,98,10],[99,9,99,10],[108,9,108,10],[111,9,111,10],[112,9,112,10],[51,11,51,12],[52,11,52,12],[53,11,53,12],[54,11,54,12],[55,11,55,12],[56,11,56,12],[57,11,57,12],[58,11,58,12],[59,11,59,12],[60,11,60,12],[61,11,61,12],[62,11,62,12],[63,11,63,12],[105,9,105,10],[106,9,106,10],[107,9,107,10],[74,11,74,12],[75,11,75,12],[110,9,110,10],[109,9,109,10],[100,9,100,10],[101,9,101,10],[71,9,71,10],[72,9,72,10],[73,9,73,10],[74,9,74,10],[94,9,94,10],[85,9,85,10],[86,9,86,10],[87,9,87,10],[88,9,88,10],[89,9,89,10],[80,9,80,10],[81,9,81,10],[82,9,82,10],[83,9,83,10],[84,9,84,10],[90,9,90,10],[91,9,91,10],[92,9,92,10],[93,9,93,10],[111,7,111,8],[112,7,112,8],[51,9,51,10],[52,9,52,10],[53,9,53,10],[54,9,54,10],[55,9,55,10],[56,9,56,10],[57,9,57,10],[58,9,58,10],[59,9,59,10],[60,9,60,10],[61,9,61,10],[62,9,62,10],[63,9,63,10],[64,9,64,10],[106,7,106,8],[107,7,107,8],[108,7,108,8],[75,9,75,10],[76,9,76,10],[77,9,77,10],[78,9,78,10],[79,9,79,10],[109,7,109,8],[110,7,110,8],[101,7,101,8],[102,7,102,8],[103,7,103,8],[104,7,104,8],[105,7,105,8],[96,7,96,8],[97,7,97,8],[98,7,98,8],[99,7,99,8],[100,7,100,8],[91,7,91,8],[92,7,92,8],[93,7,93,8],[94,7,94,8],[95,7,95,8],[86,7,86,8],[87,7,87,8],[88,7,88,8],[89,7,89,8],[90,7,90,8],[81,7,81,8],[82,7,82,8],[83,7,83,8],[84,7,84,8],[85,7,85,8],[76,7,76,8],[77,7,77,8],[78,7,78,8],[79,7,79,8],[80,7,80,8],[71,7,71,8],[72,7,72,8],[73,7,73,8],[74,7,74,8],[75,7,75,8],[66,7,66,8],[67,7,67,8],[68,7,68,8],[69,7,69,8],[70,7,70,8],[50,14,50,15],[51,7,51,8],[52,7,52,8],[53,7,53,8],[54,7,54,8],[70,9,70,10],[64,11,64,12],[65,11,65,12],[66,11,66,12],[67,11,67,12],[68,11,68,12],[69,11,69,12],[70,11,70,12],[68,14,68,15],[69,14,69,15],[70,14,70,15],[65,9,65,10],[66,9,66,10],[67,9,67,10],[68,9,68,10],[69,9,69,10],[63,14,63,15],[64,14,64,15],[65,14,65,15],[110,3,110,4],[50,7,50,8],[50,11,50,12],[50,9,50,10],[55,7,55,8],[56,7,56,8],[57,7,57,8],[58,7,58,8],[59,7,59,8],[60,7,60,8],[61,7,61,8],[62,7,62,8],[63,7,63,8],[64,7,64,8],[65,7,65,8],[105,3,105,4],[106,3,106,4],[107,3,107,4],[108,3,108,4],[109,3,109,4],[100,3,100,4],[101,3,101,4],[102,3,102,4],[103,3,103,4],[104,3,104,4],[95,3,95,4],[96,3,96,4],[97,3,97,4],[98,3,98,4],[99,3,99,4],[90,3,90,4],[91,3,91,4],[92,3,92,4],[93,3,93,4],[94,3,94,4],[86,3,86,4],[87,3,87,4],[88,3,88,4],[89,3,89,4],[80,3,80,4],[81,3,81,4],[82,3,82,4],[83,3,83,4],[84,3,84,4],[77,3,77,4],[78,3,78,4],[79,3,79,4],[70,3,70,4],[71,3,71,4],[72,3,72,4],[73,3,73,4],[74,3,74,4],[85,3,85,4],[68,3,68,4],[69,3,69,4],[60,3,60,4],[61,3,61,4],[62,3,62,4],[63,3,63,4],[64,3,64,4],[75,3,75,4],[76,3,76,4],[59,3,59,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[54,3,54,4],[65,3,65,4],[66,3,66,4],[67,3,67,4],[111,3,111,4],[112,3,112,4],[2,4,3,14],[10,4,10,5],[14,4,14,5],[16,4,16,5],[22,4,22,5],[32,4,32,5],[10,12,10,13],[12,12,12,13],[30,4,30,5],[28,4,28,5],[18,4,18,5],[6,2,6,4],[24,4,24,5],[26,4,26,5],[6,10,6,12],[8,12,8,13],[8,4,8,5],[20,4,20,5],[55,3,55,4],[56,3,56,4],[57,3,57,4],[58,3,58,4]]}
[]
[]
[null,null,null,null,"SIMULADOR DE PRÉSTAMOS PERSONALES INTERBANK"]
[]
[]
[]
[null,null,"DATOS DE SOLICITUD",null,null,null,null,null,null,null,"DEL PRÉSTAMO"]
[]
[null,null,null,null,"MONEDA",null,"SOLES",null,null,null,null,null,"MONTO A FINANCIAR",null,{"$f":"+G52","v":12910.1}]
[]
[null,null,null,null,"FECHA DE DESEMBOLSO",null,"2024-10-23",null,null,null,null,null,"TCEA",null,{"$f":"+'Simulador DATOS'!$C$10","v":0.38721053992530896}]
[]
[null,null,null,null,"MONTO A DESEMBOLSAR",null,12222,null,null,null,null,null,"CUOTA",null,{"$f":"+MIN(O52:P53)","v":443.25}]
[]
[null,null,null,null,"PLAZO",null,60,null,null,null,null,null,"PRIMERA FECHA DE PAGO",null,{"$f":"+F52","v":"2024-12-02"}]
[]
[null,null,null,null,"TEA (1)",null,0.36499999999999999,null,null,null,null,null,"TOTAL AMORTIZACIÓN",null,{"$f":"+SUM('Simulador DATOS'!O8:O128)","v":12799}]
[]
[null,null,null,null,"FECHA DE PAGO",null,2,null,null,null,null,null,"TOTAL INTERESES",null,{"$f":"+SUM('Simulador DATOS'!P8:P128)","v":13195.759999999998}]
[]
[null,null,null,null,"TIPO DE CUOTA",null,"ORDINARIA",null,null,null,null,null,"TOTAL DESGRAVAMEN",null,{"$f":"+SUM('Simulador DATOS'!Q8:Q128)","v":0}]
[]
[null,null,null,null,"PERIODO DE GRACIA (MESES)",null,0,null,null,null,null,null,"TOTAL COMISIONES",null,{"$f":"+SUM('Simulador DATOS'!S8:S128)","v":600}]
[null,null,null,null,null,null,null,null,{"$f":"+IF((G13>300000)*(G9=\"DÓLARES\")*(G25<>\"SIN SEGURO (ENDOSO)\"),\"Corregir conforme a (3)\",\"\")","v":""}]
[null,null,null,null,"TIPO DE SEGURO DE DESG (2) (3) (4)",null,"SIN SEGURO (ENDOSO)",null,{"$f":"+IF((G15<24)*(G25=\"CON DEVOLUC.\"),\"Corregir conforme a (4)\",\"\")","v":""}]
[]
[null,null,null,null,"PRIMA DE SEGURO DESG.",null,{"$f":"+IF(G25=\"SIN DEVOLUC.\",0.075%,IF(G25=\"CON DEVOLUC.\",0.0854%,0))","v":0},null,null,null,"LEYENDA:"]
[]
[null,null,null,null,"SEGURO DE PROTEC. CRÉDITOS (5) (7)",null,"SÍ",null,null,null,null,null,"Dato a ingresar y/o elegir de lista desplegable"]
[]
[null,null,null,null,"PRIMA DE SEGURO DE PROTEC. CRÉD.",null,{"$f":"IF(AND(G29=\"SÍ\", G9=\"SOLES\"),IFERROR(VLOOKUP((G15+G23),LEYENDA!G5:H66,2,FALSE),0),IF(AND(G29=\"SÍ\", G9=\"DÓLARES\"),IFERROR(VLOOKUP((G15+G23),LEYENDA!G5:J66,4,FALSE),0),0))","v":577},null,null,null,null,null,"Dato formulado, no modificar"]
[]
[null,null,null,null,"TIPO DE ENVÍO DE EECC (6)",null,"FÍSICO - SIN PLANILLA"]
[]
[null,null,null,null,"COMISIÓN POR ENVÍO DE EECC (6)",null,{"$f":"+VLOOKUP(G9&G33, LEYENDA!P6:S11,4,0)","v":10}]
[]
[]
[null,null,null,"NOTA: "]
[null,null,null,"(1)","La TEA es fija durante todo el crédito. Consulta tu tasa aplicable ingresando a Interbank.pe, por nuestra App, visitando nuestras Tiendas o llamando al (01)3119000"]
[]
[null,null,null,"(2)","Se calcula sobre el saldo de capital del crédito. El cliente puede elegir contratar el seguro de desgravamen tradicional sin devolución o seguro de desgravamen con devolución. Consultar condiciones y requisitos en www.Interbank.pe"]
[]
[null,null,null,"(3)","El cliente no tiene la obligación de tomar el seguro de Interbank, puede endosar el suyo (ya existente) a favor de Interbank y/o uno similar provisto por otra compañía. Para financiamientos mayores a USD $300,000 solo se podrá desembolsar con un seguro endosado. "]
[]
[null,null,null,"(4)","El seguro de desgravamen con devolución aplica únicamente para financiamientos con plazos de 24 meses o más."]
[null,null,null,"(5)","Este seguro es a solicitud del cliente. El importe de la prima será incluida en el capital y financiada según las condiciones del crédito."]
[null,null,null,"(6)","La comisión por envío de Estado de Cuenta varía según la moneda y si tiene Cuenta Sueldo con Interbank: en soles, S/4 con planilla y S/10 sin planilla; en dólares, USD $1.5 con planilla y USD $3.5 sin planilla."]
[]
[null,null,null,"(7)","Plazo máximo de 60 meses. "]
[]
[null,null,null,"CUOTA",null,"VENCIMIENTO","SALDO CAPITAL","AMORTIZACIÓN",null,"INTERÉS",null,"DESGRAVAMEN",null,"COMISIÓN","CUOTA"]
[null,null,null,1,null,{"$f":"+IFERROR(VLOOKUP(D52, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2024-12-02"},{"$f":"+IFERROR(VLOOKUP(D52, 'Simulador DATOS'!F:R,9,0),\"\")","v":12910.1},{"$f":"+IFERROR(VLOOKUP(D52, 'Simulador DATOS'!F:R,10,0),\"\")","v":94.12},null,{"$f":"+IFERROR(VLOOKUP(D52, 'Simulador DATOS'!F:R,11,0),\"\")","v":339.13},null,{"$f":"+IFERROR(VLOOKUP(D52, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D52, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D52, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,{"$f":"+IF(D52=\"\", \"\", IF((D52+1)>$G$15,\"\", D52+1))","v":2},null,{"$f":"+IFERROR(VLOOKUP(D53, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2025-01-02"},{"$f":"+IFERROR(VLOOKUP(D53, 'Simulador DATOS'!F:R,9,0),\"\")","v":12815.98},{"$f":"+IFERROR(VLOOKUP(D53, 'Simulador DATOS'!F:R,10,0),\"\")","v":85.220000000000027},null,{"$f":"+IFERROR(VLOOKUP(D53, 'Simulador DATOS'!F:R,11,0),\"\")","v":348.03},null,{"$f":"+IFERROR(VLOOKUP(D53, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D53, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D53, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,3,null,{"$f":"+IFERROR(VLOOKUP(D54, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2025-02-02"},{"$f":"+IFERROR(VLOOKUP(D54, 'Simulador DATOS'!F:R,9,0),\"\")","v":12730.76},{"$f":"+IFERROR(VLOOKUP(D54, 'Simulador DATOS'!F:R,10,0),\"\")","v":87.529999999999973},null,{"$f":"+IFERROR(VLOOKUP(D54, 'Simulador DATOS'!F:R,11,0),\"\")","v":345.72},null,{"$f":"+IFERROR(VLOOKUP(D54, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D54, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D54, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,4,null,{"$f":"+IFERROR(VLOOKUP(D55, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2025-03-02"},{"$f":"+IFERROR(VLOOKUP(D55, 'Simulador DATOS'!F:R,9,0),\"\")","v":12643.23},{"$f":"+IFERROR(VLOOKUP(D55, 'Simulador DATOS'!F:R,10,0),\"\")","v":123.54000000000002},null,{"$f":"+IFERROR(VLOOKUP(D55, 'Simulador DATOS'!F:R,11,0),\"\")","v":309.70999999999998},null,{"$f":"+IFERROR(VLOOKUP(D55, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D55, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D55, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,5,null,{"$f":"+IFERROR(VLOOKUP(D56, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2025-04-02"},{"$f":"+IFERROR(VLOOKUP(D56, 'Simulador DATOS'!F:R,9,0),\"\")","v":12519.689999999999},{"$f":"+IFERROR(VLOOKUP(D56, 'Simulador DATOS'!F:R,10,0),\"\")","v":93.259999999999991},null,{"$f":"+IFERROR(VLOOKUP(D56, 'Simulador DATOS'!F:R,11,0),\"\")","v":339.99},null,{"$f":"+IFERROR(VLOOKUP(D56, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D56, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D56, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,6,null,{"$f":"+IFERROR(VLOOKUP(D57, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2025-05-02"},{"$f":"+IFERROR(VLOOKUP(D57, 'Simulador DATOS'!F:R,9,0),\"\")","v":12426.429999999998},{"$f":"+IFERROR(VLOOKUP(D57, 'Simulador DATOS'!F:R,10,0),\"\")","v":106.82},null,{"$f":"+IFERROR(VLOOKUP(D57, 'Simulador DATOS'!F:R,11,0),\"\")","v":326.43},null,{"$f":"+IFERROR(VLOOKUP(D57, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D57, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D57, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,7,null,{"$f":"+IFERROR(VLOOKUP(D58, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2025-06-02"},{"$f":"+IFERROR(VLOOKUP(D58, 'Simulador DATOS'!F:R,9,0),\"\")","v":12319.609999999999},{"$f":"+IFERROR(VLOOKUP(D58, 'Simulador DATOS'!F:R,10,0),\"\")","v":98.699999999999989},null,{"$f":"+IFERROR(VLOOKUP(D58, 'Simulador DATOS'!F:R,11,0),\"\")","v":334.55},null,{"$f":"+IFERROR(VLOOKUP(D58, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D58, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D58, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,8,null,{"$f":"+IFERROR(VLOOKUP(D59, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2025-07-02"},{"$f":"+IFERROR(VLOOKUP(D59, 'Simulador DATOS'!F:R,9,0),\"\")","v":12220.909999999998},{"$f":"+IFERROR(VLOOKUP(D59, 'Simulador DATOS'!F:R,10,0),\"\")","v":112.22000000000003},null,{"$f":"+IFERROR(VLOOKUP(D59, 'Simulador DATOS'!F:R,11,0),\"\")","v":321.02999999999997},null,{"$f":"+IFERROR(VLOOKUP(D59, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D59, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D59, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,9,null,{"$f":"+IFERROR(VLOOKUP(D60, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2025-08-02"},{"$f":"+IFERROR(VLOOKUP(D60, 'Simulador DATOS'!F:R,9,0),\"\")","v":12108.689999999999},{"$f":"+IFERROR(VLOOKUP(D60, 'Simulador DATOS'!F:R,10,0),\"\")","v":104.43},null,{"$f":"+IFERROR(VLOOKUP(D60, 'Simulador DATOS'!F:R,11,0),\"\")","v":328.82},null,{"$f":"+IFERROR(VLOOKUP(D60, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D60, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D60, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,10,null,{"$f":"+IFERROR(VLOOKUP(D61, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2025-09-02"},{"$f":"+IFERROR(VLOOKUP(D61, 'Simulador DATOS'!F:R,9,0),\"\")","v":12004.259999999998},{"$f":"+IFERROR(VLOOKUP(D61, 'Simulador DATOS'!F:R,10,0),\"\")","v":107.25999999999999},null,{"$f":"+IFERROR(VLOOKUP(D61, 'Simulador DATOS'!F:R,11,0),\"\")","v":325.99},null,{"$f":"+IFERROR(VLOOKUP(D61, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D61, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D61, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,11,null,{"$f":"+IFERROR(VLOOKUP(D62, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2025-10-02"},{"$f":"+IFERROR(VLOOKUP(D62, 'Simulador DATOS'!F:R,9,0),\"\")","v":11896.999999999998},{"$f":"+IFERROR(VLOOKUP(D62, 'Simulador DATOS'!F:R,10,0),\"\")","v":120.73000000000002},null,{"$f":"+IFERROR(VLOOKUP(D62, 'Simulador DATOS'!F:R,11,0),\"\")","v":312.52},null,{"$f":"+IFERROR(VLOOKUP(D62, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D62, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D62, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,12,null,{"$f":"+IFERROR(VLOOKUP(D63, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2025-11-02"},{"$f":"+IFERROR(VLOOKUP(D63, 'Simulador DATOS'!F:R,9,0),\"\")","v":11776.269999999999},{"$f":"+IFERROR(VLOOKUP(D63, 'Simulador DATOS'!F:R,10,0),\"\")","v":113.44999999999999},null,{"$f":"+IFERROR(VLOOKUP(D63, 'Simulador DATOS'!F:R,11,0),\"\")","v":319.8},null,{"$f":"+IFERROR(VLOOKUP(D63, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D63, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D63, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,13,null,{"$f":"+IFERROR(VLOOKUP(D64, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2025-12-02"},{"$f":"+IFERROR(VLOOKUP(D64, 'Simulador DATOS'!F:R,9,0),\"\")","v":11662.819999999998},{"$f":"+IFERROR(VLOOKUP(D64, 'Simulador DATOS'!F:R,10,0),\"\")","v":126.88},null,{"$f":"+IFERROR(VLOOKUP(D64, 'Simulador DATOS'!F:R,11,0),\"\")","v":306.37},null,{"$f":"+IFERROR(VLOOKUP(D64, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D64, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D64, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,14,null,{"$f":"+IFERROR(VLOOKUP(D65, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2026-01-02"},{"$f":"+IFERROR(VLOOKUP(D65, 'Simulador DATOS'!F:R,9,0),\"\")","v":11535.939999999999},{"$f":"+IFERROR(VLOOKUP(D65, 'Simulador DATOS'!F:R,10,0),\"\")","v":119.98000000000002},null,{"$f":"+IFERROR(VLOOKUP(D65, 'Simulador DATOS'!F:R,11,0),\"\")","v":313.27},null,{"$f":"+IFERROR(VLOOKUP(D65, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D65, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D65, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,15,null,{"$f":"+IFERROR(VLOOKUP(D66, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2026-02-02"},{"$f":"+IFERROR(VLOOKUP(D66, 'Simulador DATOS'!F:R,9,0),\"\")","v":11415.96},{"$f":"+IFERROR(VLOOKUP(D66, 'Simulador DATOS'!F:R,10,0),\"\")","v":123.24000000000001},null,{"$f":"+IFERROR(VLOOKUP(D66, 'Simulador DATOS'!F:R,11,0),\"\")","v":310.01},null,{"$f":"+IFERROR(VLOOKUP(D66, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D66, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D66, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,16,null,{"$f":"+IFERROR(VLOOKUP(D67, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2026-03-02"},{"$f":"+IFERROR(VLOOKUP(D67, 'Simulador DATOS'!F:R,9,0),\"\")","v":11292.72},{"$f":"+IFERROR(VLOOKUP(D67, 'Simulador DATOS'!F:R,10,0),\"\")","v":156.62},null,{"$f":"+IFERROR(VLOOKUP(D67, 'Simulador DATOS'!F:R,11,0),\"\")","v":276.63},null,{"$f":"+IFERROR(VLOOKUP(D67, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D67, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D67, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,17,null,{"$f":"+IFERROR(VLOOKUP(D68, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2026-04-02"},{"$f":"+IFERROR(VLOOKUP(D68, 'Simulador DATOS'!F:R,9,0),\"\")","v":11136.099999999999},{"$f":"+IFERROR(VLOOKUP(D68, 'Simulador DATOS'!F:R,10,0),\"\")","v":130.83999999999997},null,{"$f":"+IFERROR(VLOOKUP(D68, 'Simulador DATOS'!F:R,11,0),\"\")","v":302.41000000000003},null,{"$f":"+IFERROR(VLOOKUP(D68, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D68, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D68, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,18,null,{"$f":"+IFERROR(VLOOKUP(D69, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2026-05-02"},{"$f":"+IFERROR(VLOOKUP(D69, 'Simulador DATOS'!F:R,9,0),\"\")","v":11005.259999999998},{"$f":"+IFERROR(VLOOKUP(D69, 'Simulador DATOS'!F:R,10,0),\"\")","v":144.16000000000003},null,{"$f":"+IFERROR(VLOOKUP(D69, 'Simulador DATOS'!F:R,11,0),\"\")","v":289.08999999999997},null,{"$f":"+IFERROR(VLOOKUP(D69, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D69, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D69, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,19,null,{"$f":"+IFERROR(VLOOKUP(D70, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2026-06-02"},{"$f":"+IFERROR(VLOOKUP(D70, 'Simulador DATOS'!F:R,9,0),\"\")","v":10861.099999999999},{"$f":"+IFERROR(VLOOKUP(D70, 'Simulador DATOS'!F:R,10,0),\"\")","v":138.31},null,{"$f":"+IFERROR(VLOOKUP(D70, 'Simulador DATOS'!F:R,11,0),\"\")","v":294.94},null,{"$f":"+IFERROR(VLOOKUP(D70, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D70, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D70, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,20,null,{"$f":"+IFERROR(VLOOKUP(D71, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2026-07-02"},{"$f":"+IFERROR(VLOOKUP(D71, 'Simulador DATOS'!F:R,9,0),\"\")","v":10722.789999999999},{"$f":"+IFERROR(VLOOKUP(D71, 'Simulador DATOS'!F:R,10,0),\"\")","v":151.57999999999998},null,{"$f":"+IFERROR(VLOOKUP(D71, 'Simulador DATOS'!F:R,11,0),\"\")","v":281.67},null,{"$f":"+IFERROR(VLOOKUP(D71, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D71, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D71, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,21,null,{"$f":"+IFERROR(VLOOKUP(D72, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2026-08-02"},{"$f":"+IFERROR(VLOOKUP(D72, 'Simulador DATOS'!F:R,9,0),\"\")","v":10571.21},{"$f":"+IFERROR(VLOOKUP(D72, 'Simulador DATOS'!F:R,10,0),\"\")","v":146.18},null,{"$f":"+IFERROR(VLOOKUP(D72, 'Simulador DATOS'!F:R,11,0),\"\")","v":287.07},null,{"$f":"+IFERROR(VLOOKUP(D72, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D72, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D72, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,22,null,{"$f":"+IFERROR(VLOOKUP(D73, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2026-09-02"},{"$f":"+IFERROR(VLOOKUP(D73, 'Simulador DATOS'!F:R,9,0),\"\")","v":10425.029999999999},{"$f":"+IFERROR(VLOOKUP(D73, 'Simulador DATOS'!F:R,10,0),\"\")","v":150.14999999999998},null,{"$f":"+IFERROR(VLOOKUP(D73, 'Simulador DATOS'!F:R,11,0),\"\")","v":283.10000000000002},null,{"$f":"+IFERROR(VLOOKUP(D73, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D73, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D73, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,23,null,{"$f":"+IFERROR(VLOOKUP(D74, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2026-10-02"},{"$f":"+IFERROR(VLOOKUP(D74, 'Simulador DATOS'!F:R,9,0),\"\")","v":10274.879999999999},{"$f":"+IFERROR(VLOOKUP(D74, 'Simulador DATOS'!F:R,10,0),\"\")","v":163.33999999999997},null,{"$f":"+IFERROR(VLOOKUP(D74, 'Simulador DATOS'!F:R,11,0),\"\")","v":269.91000000000003},null,{"$f":"+IFERROR(VLOOKUP(D74, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D74, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D74, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,24,null,{"$f":"+IFERROR(VLOOKUP(D75, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2026-11-02"},{"$f":"+IFERROR(VLOOKUP(D75, 'Simulador DATOS'!F:R,9,0),\"\")","v":10111.539999999999},{"$f":"+IFERROR(VLOOKUP(D75, 'Simulador DATOS'!F:R,10,0),\"\")","v":158.66000000000003},null,{"$f":"+IFERROR(VLOOKUP(D75, 'Simulador DATOS'!F:R,11,0),\"\")","v":274.58999999999997},null,{"$f":"+IFERROR(VLOOKUP(D75, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D75, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D75, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,25,null,{"$f":"+IFERROR(VLOOKUP(D76, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2026-12-02"},{"$f":"+IFERROR(VLOOKUP(D76, 'Simulador DATOS'!F:R,9,0),\"\")","v":9952.8799999999992},{"$f":"+IFERROR(VLOOKUP(D76, 'Simulador DATOS'!F:R,10,0),\"\")","v":171.8},null,{"$f":"+IFERROR(VLOOKUP(D76, 'Simulador DATOS'!F:R,11,0),\"\")","v":261.45},null,{"$f":"+IFERROR(VLOOKUP(D76, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D76, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D76, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,26,null,{"$f":"+IFERROR(VLOOKUP(D77, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2027-01-02"},{"$f":"+IFERROR(VLOOKUP(D77, 'Simulador DATOS'!F:R,9,0),\"\")","v":9781.08},{"$f":"+IFERROR(VLOOKUP(D77, 'Simulador DATOS'!F:R,10,0),\"\")","v":167.63},null,{"$f":"+IFERROR(VLOOKUP(D77, 'Simulador DATOS'!F:R,11,0),\"\")","v":265.62},null,{"$f":"+IFERROR(VLOOKUP(D77, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D77, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D77, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,27,null,{"$f":"+IFERROR(VLOOKUP(D78, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2027-02-02"},{"$f":"+IFERROR(VLOOKUP(D78, 'Simulador DATOS'!F:R,9,0),\"\")","v":9613.4500000000007},{"$f":"+IFERROR(VLOOKUP(D78, 'Simulador DATOS'!F:R,10,0),\"\")","v":172.19},null,{"$f":"+IFERROR(VLOOKUP(D78, 'Simulador DATOS'!F:R,11,0),\"\")","v":261.06},null,{"$f":"+IFERROR(VLOOKUP(D78, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D78, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D78, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,28,null,{"$f":"+IFERROR(VLOOKUP(D79, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2027-03-02"},{"$f":"+IFERROR(VLOOKUP(D79, 'Simulador DATOS'!F:R,9,0),\"\")","v":9441.26},{"$f":"+IFERROR(VLOOKUP(D79, 'Simulador DATOS'!F:R,10,0),\"\")","v":201.98},null,{"$f":"+IFERROR(VLOOKUP(D79, 'Simulador DATOS'!F:R,11,0),\"\")","v":231.27},null,{"$f":"+IFERROR(VLOOKUP(D79, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D79, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D79, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,29,null,{"$f":"+IFERROR(VLOOKUP(D80, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2027-04-02"},{"$f":"+IFERROR(VLOOKUP(D80, 'Simulador DATOS'!F:R,9,0),\"\")","v":9239.2800000000007},{"$f":"+IFERROR(VLOOKUP(D80, 'Simulador DATOS'!F:R,10,0),\"\")","v":182.35},null,{"$f":"+IFERROR(VLOOKUP(D80, 'Simulador DATOS'!F:R,11,0),\"\")","v":250.9},null,{"$f":"+IFERROR(VLOOKUP(D80, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D80, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D80, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,30,null,{"$f":"+IFERROR(VLOOKUP(D81, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2027-05-02"},{"$f":"+IFERROR(VLOOKUP(D81, 'Simulador DATOS'!F:R,9,0),\"\")","v":9056.93},{"$f":"+IFERROR(VLOOKUP(D81, 'Simulador DATOS'!F:R,10,0),\"\")","v":195.34},null,{"$f":"+IFERROR(VLOOKUP(D81, 'Simulador DATOS'!F:R,11,0),\"\")","v":237.91},null,{"$f":"+IFERROR(VLOOKUP(D81, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D81, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D81, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,31,null,{"$f":"+IFERROR(VLOOKUP(D82, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2027-06-02"},{"$f":"+IFERROR(VLOOKUP(D82, 'Simulador DATOS'!F:R,9,0),\"\")","v":8861.59},{"$f":"+IFERROR(VLOOKUP(D82, 'Simulador DATOS'!F:R,10,0),\"\")","v":192.6},null,{"$f":"+IFERROR(VLOOKUP(D82, 'Simulador DATOS'!F:R,11,0),\"\")","v":240.65},null,{"$f":"+IFERROR(VLOOKUP(D82, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D82, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D82, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,32,null,{"$f":"+IFERROR(VLOOKUP(D83, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2027-07-02"},{"$f":"+IFERROR(VLOOKUP(D83, 'Simulador DATOS'!F:R,9,0),\"\")","v":8668.99},{"$f":"+IFERROR(VLOOKUP(D83, 'Simulador DATOS'!F:R,10,0),\"\")","v":205.53},null,{"$f":"+IFERROR(VLOOKUP(D83, 'Simulador DATOS'!F:R,11,0),\"\")","v":227.72},null,{"$f":"+IFERROR(VLOOKUP(D83, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D83, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D83, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,33,null,{"$f":"+IFERROR(VLOOKUP(D84, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2027-08-02"},{"$f":"+IFERROR(VLOOKUP(D84, 'Simulador DATOS'!F:R,9,0),\"\")","v":8463.4599999999991},{"$f":"+IFERROR(VLOOKUP(D84, 'Simulador DATOS'!F:R,10,0),\"\")","v":203.42},null,{"$f":"+IFERROR(VLOOKUP(D84, 'Simulador DATOS'!F:R,11,0),\"\")","v":229.83},null,{"$f":"+IFERROR(VLOOKUP(D84, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D84, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D84, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,{"$f":"+IF(D84=\"\", \"\", IF((D84+1)>$G$15,\"\", D84+1))","v":34},null,{"$f":"+IFERROR(VLOOKUP(D85, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2027-09-02"},{"$f":"+IFERROR(VLOOKUP(D85, 'Simulador DATOS'!F:R,9,0),\"\")","v":8260.0399999999991},{"$f":"+IFERROR(VLOOKUP(D85, 'Simulador DATOS'!F:R,10,0),\"\")","v":208.94},null,{"$f":"+IFERROR(VLOOKUP(D85, 'Simulador DATOS'!F:R,11,0),\"\")","v":224.31},null,{"$f":"+IFERROR(VLOOKUP(D85, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D85, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D85, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,35,null,{"$f":"+IFERROR(VLOOKUP(D86, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2027-10-02"},{"$f":"+IFERROR(VLOOKUP(D86, 'Simulador DATOS'!F:R,9,0),\"\")","v":8051.0999999999995},{"$f":"+IFERROR(VLOOKUP(D86, 'Simulador DATOS'!F:R,10,0),\"\")","v":221.76},null,{"$f":"+IFERROR(VLOOKUP(D86, 'Simulador DATOS'!F:R,11,0),\"\")","v":211.49},null,{"$f":"+IFERROR(VLOOKUP(D86, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D86, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D86, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,36,null,{"$f":"+IFERROR(VLOOKUP(D87, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2027-11-02"},{"$f":"+IFERROR(VLOOKUP(D87, 'Simulador DATOS'!F:R,9,0),\"\")","v":7829.3399999999992},{"$f":"+IFERROR(VLOOKUP(D87, 'Simulador DATOS'!F:R,10,0),\"\")","v":220.64},null,{"$f":"+IFERROR(VLOOKUP(D87, 'Simulador DATOS'!F:R,11,0),\"\")","v":212.61},null,{"$f":"+IFERROR(VLOOKUP(D87, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D87, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D87, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,37,null,{"$f":"+IFERROR(VLOOKUP(D88, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2027-12-02"},{"$f":"+IFERROR(VLOOKUP(D88, 'Simulador DATOS'!F:R,9,0),\"\")","v":7608.6999999999989},{"$f":"+IFERROR(VLOOKUP(D88, 'Simulador DATOS'!F:R,10,0),\"\")","v":233.38},null,{"$f":"+IFERROR(VLOOKUP(D88, 'Simulador DATOS'!F:R,11,0),\"\")","v":199.87},null,{"$f":"+IFERROR(VLOOKUP(D88, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D88, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D88, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,38,null,{"$f":"+IFERROR(VLOOKUP(D89, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2028-01-02"},{"$f":"+IFERROR(VLOOKUP(D89, 'Simulador DATOS'!F:R,9,0),\"\")","v":7375.3199999999988},{"$f":"+IFERROR(VLOOKUP(D89, 'Simulador DATOS'!F:R,10,0),\"\")","v":232.97},null,{"$f":"+IFERROR(VLOOKUP(D89, 'Simulador DATOS'!F:R,11,0),\"\")","v":200.28},null,{"$f":"+IFERROR(VLOOKUP(D89, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D89, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D89, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,39,null,{"$f":"+IFERROR(VLOOKUP(D90, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2028-02-02"},{"$f":"+IFERROR(VLOOKUP(D90, 'Simulador DATOS'!F:R,9,0),\"\")","v":7142.3499999999985},{"$f":"+IFERROR(VLOOKUP(D90, 'Simulador DATOS'!F:R,10,0),\"\")","v":239.29},null,{"$f":"+IFERROR(VLOOKUP(D90, 'Simulador DATOS'!F:R,11,0),\"\")","v":193.96},null,{"$f":"+IFERROR(VLOOKUP(D90, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D90, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D90, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,40,null,{"$f":"+IFERROR(VLOOKUP(D91, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2028-03-02"},{"$f":"+IFERROR(VLOOKUP(D91, 'Simulador DATOS'!F:R,9,0),\"\")","v":6903.0599999999986},{"$f":"+IFERROR(VLOOKUP(D91, 'Simulador DATOS'!F:R,10,0),\"\")","v":258.03999999999996},null,{"$f":"+IFERROR(VLOOKUP(D91, 'Simulador DATOS'!F:R,11,0),\"\")","v":175.21},null,{"$f":"+IFERROR(VLOOKUP(D91, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D91, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D91, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,41,null,{"$f":"+IFERROR(VLOOKUP(D92, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2028-04-02"},{"$f":"+IFERROR(VLOOKUP(D92, 'Simulador DATOS'!F:R,9,0),\"\")","v":6645.0199999999986},{"$f":"+IFERROR(VLOOKUP(D92, 'Simulador DATOS'!F:R,10,0),\"\")","v":252.8},null,{"$f":"+IFERROR(VLOOKUP(D92, 'Simulador DATOS'!F:R,11,0),\"\")","v":180.45},null,{"$f":"+IFERROR(VLOOKUP(D92, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D92, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D92, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,42,null,{"$f":"+IFERROR(VLOOKUP(D93, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2028-05-02"},{"$f":"+IFERROR(VLOOKUP(D93, 'Simulador DATOS'!F:R,9,0),\"\")","v":6392.2199999999984},{"$f":"+IFERROR(VLOOKUP(D93, 'Simulador DATOS'!F:R,10,0),\"\")","v":265.34000000000003},null,{"$f":"+IFERROR(VLOOKUP(D93, 'Simulador DATOS'!F:R,11,0),\"\")","v":167.91},null,{"$f":"+IFERROR(VLOOKUP(D93, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D93, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D93, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,43,null,{"$f":"+IFERROR(VLOOKUP(D94, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2028-06-02"},{"$f":"+IFERROR(VLOOKUP(D94, 'Simulador DATOS'!F:R,9,0),\"\")","v":6126.8799999999983},{"$f":"+IFERROR(VLOOKUP(D94, 'Simulador DATOS'!F:R,10,0),\"\")","v":266.87},null,{"$f":"+IFERROR(VLOOKUP(D94, 'Simulador DATOS'!F:R,11,0),\"\")","v":166.38},null,{"$f":"+IFERROR(VLOOKUP(D94, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D94, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D94, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,44,null,{"$f":"+IFERROR(VLOOKUP(D95, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2028-07-02"},{"$f":"+IFERROR(VLOOKUP(D95, 'Simulador DATOS'!F:R,9,0),\"\")","v":5860.0099999999984},{"$f":"+IFERROR(VLOOKUP(D95, 'Simulador DATOS'!F:R,10,0),\"\")","v":279.32},null,{"$f":"+IFERROR(VLOOKUP(D95, 'Simulador DATOS'!F:R,11,0),\"\")","v":153.93},null,{"$f":"+IFERROR(VLOOKUP(D95, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D95, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D95, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,45,null,{"$f":"+IFERROR(VLOOKUP(D96, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2028-08-02"},{"$f":"+IFERROR(VLOOKUP(D96, 'Simulador DATOS'!F:R,9,0),\"\")","v":5580.6899999999987},{"$f":"+IFERROR(VLOOKUP(D96, 'Simulador DATOS'!F:R,10,0),\"\")","v":281.7},null,{"$f":"+IFERROR(VLOOKUP(D96, 'Simulador DATOS'!F:R,11,0),\"\")","v":151.55000000000001},null,{"$f":"+IFERROR(VLOOKUP(D96, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D96, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D96, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,46,null,{"$f":"+IFERROR(VLOOKUP(D97, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2028-09-02"},{"$f":"+IFERROR(VLOOKUP(D97, 'Simulador DATOS'!F:R,9,0),\"\")","v":5298.9899999999989},{"$f":"+IFERROR(VLOOKUP(D97, 'Simulador DATOS'!F:R,10,0),\"\")","v":289.35000000000002},null,{"$f":"+IFERROR(VLOOKUP(D97, 'Simulador DATOS'!F:R,11,0),\"\")","v":143.9},null,{"$f":"+IFERROR(VLOOKUP(D97, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D97, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D97, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,47,null,{"$f":"+IFERROR(VLOOKUP(D98, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2028-10-02"},{"$f":"+IFERROR(VLOOKUP(D98, 'Simulador DATOS'!F:R,9,0),\"\")","v":5009.6399999999985},{"$f":"+IFERROR(VLOOKUP(D98, 'Simulador DATOS'!F:R,10,0),\"\")","v":301.64999999999998},null,{"$f":"+IFERROR(VLOOKUP(D98, 'Simulador DATOS'!F:R,11,0),\"\")","v":131.6},null,{"$f":"+IFERROR(VLOOKUP(D98, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D98, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D98, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,48,null,{"$f":"+IFERROR(VLOOKUP(D99, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2028-11-02"},{"$f":"+IFERROR(VLOOKUP(D99, 'Simulador DATOS'!F:R,9,0),\"\")","v":4707.9899999999989},{"$f":"+IFERROR(VLOOKUP(D99, 'Simulador DATOS'!F:R,10,0),\"\")","v":305.39999999999998},null,{"$f":"+IFERROR(VLOOKUP(D99, 'Simulador DATOS'!F:R,11,0),\"\")","v":127.85},null,{"$f":"+IFERROR(VLOOKUP(D99, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D99, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D99, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,49,null,{"$f":"+IFERROR(VLOOKUP(D100, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2028-12-02"},{"$f":"+IFERROR(VLOOKUP(D100, 'Simulador DATOS'!F:R,9,0),\"\")","v":4402.5899999999992},{"$f":"+IFERROR(VLOOKUP(D100, 'Simulador DATOS'!F:R,10,0),\"\")","v":317.60000000000002},null,{"$f":"+IFERROR(VLOOKUP(D100, 'Simulador DATOS'!F:R,11,0),\"\")","v":115.65},null,{"$f":"+IFERROR(VLOOKUP(D100, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D100, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D100, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,50,null,{"$f":"+IFERROR(VLOOKUP(D101, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2029-01-02"},{"$f":"+IFERROR(VLOOKUP(D101, 'Simulador DATOS'!F:R,9,0),\"\")","v":4084.9899999999993},{"$f":"+IFERROR(VLOOKUP(D101, 'Simulador DATOS'!F:R,10,0),\"\")","v":322.32},null,{"$f":"+IFERROR(VLOOKUP(D101, 'Simulador DATOS'!F:R,11,0),\"\")","v":110.93},null,{"$f":"+IFERROR(VLOOKUP(D101, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D101, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D101, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,51,null,{"$f":"+IFERROR(VLOOKUP(D102, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2029-02-02"},{"$f":"+IFERROR(VLOOKUP(D102, 'Simulador DATOS'!F:R,9,0),\"\")","v":3762.6699999999992},{"$f":"+IFERROR(VLOOKUP(D102, 'Simulador DATOS'!F:R,10,0),\"\")","v":331.07},null,{"$f":"+IFERROR(VLOOKUP(D102, 'Simulador DATOS'!F:R,11,0),\"\")","v":102.18},null,{"$f":"+IFERROR(VLOOKUP(D102, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D102, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D102, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,52,null,{"$f":"+IFERROR(VLOOKUP(D103, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2029-03-02"},{"$f":"+IFERROR(VLOOKUP(D103, 'Simulador DATOS'!F:R,9,0),\"\")","v":3431.599999999999},{"$f":"+IFERROR(VLOOKUP(D103, 'Simulador DATOS'!F:R,10,0),\"\")","v":349.19},null,{"$f":"+IFERROR(VLOOKUP(D103, 'Simulador DATOS'!F:R,11,0),\"\")","v":84.06},null,{"$f":"+IFERROR(VLOOKUP(D103, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D103, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D103, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,53,null,{"$f":"+IFERROR(VLOOKUP(D104, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2029-04-02"},{"$f":"+IFERROR(VLOOKUP(D104, 'Simulador DATOS'!F:R,9,0),\"\")","v":3082.4099999999989},{"$f":"+IFERROR(VLOOKUP(D104, 'Simulador DATOS'!F:R,10,0),\"\")","v":349.54},null,{"$f":"+IFERROR(VLOOKUP(D104, 'Simulador DATOS'!F:R,11,0),\"\")","v":83.71},null,{"$f":"+IFERROR(VLOOKUP(D104, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D104, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D104, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,54,null,{"$f":"+IFERROR(VLOOKUP(D105, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2029-05-02"},{"$f":"+IFERROR(VLOOKUP(D105, 'Simulador DATOS'!F:R,9,0),\"\")","v":2732.869999999999},{"$f":"+IFERROR(VLOOKUP(D105, 'Simulador DATOS'!F:R,10,0),\"\")","v":361.46},null,{"$f":"+IFERROR(VLOOKUP(D105, 'Simulador DATOS'!F:R,11,0),\"\")","v":71.790000000000006},null,{"$f":"+IFERROR(VLOOKUP(D105, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D105, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D105, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,55,null,{"$f":"+IFERROR(VLOOKUP(D106, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2029-06-02"},{"$f":"+IFERROR(VLOOKUP(D106, 'Simulador DATOS'!F:R,9,0),\"\")","v":2371.4099999999989},{"$f":"+IFERROR(VLOOKUP(D106, 'Simulador DATOS'!F:R,10,0),\"\")","v":368.85},null,{"$f":"+IFERROR(VLOOKUP(D106, 'Simulador DATOS'!F:R,11,0),\"\")","v":64.400000000000006},null,{"$f":"+IFERROR(VLOOKUP(D106, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D106, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D106, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,56,null,{"$f":"+IFERROR(VLOOKUP(D107, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2029-07-02"},{"$f":"+IFERROR(VLOOKUP(D107, 'Simulador DATOS'!F:R,9,0),\"\")","v":2002.559999999999},{"$f":"+IFERROR(VLOOKUP(D107, 'Simulador DATOS'!F:R,10,0),\"\")","v":380.65},null,{"$f":"+IFERROR(VLOOKUP(D107, 'Simulador DATOS'!F:R,11,0),\"\")","v":52.6},null,{"$f":"+IFERROR(VLOOKUP(D107, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D107, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D107, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,57,null,{"$f":"+IFERROR(VLOOKUP(D108, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2029-08-02"},{"$f":"+IFERROR(VLOOKUP(D108, 'Simulador DATOS'!F:R,9,0),\"\")","v":1621.9099999999989},{"$f":"+IFERROR(VLOOKUP(D108, 'Simulador DATOS'!F:R,10,0),\"\")","v":389.21},null,{"$f":"+IFERROR(VLOOKUP(D108, 'Simulador DATOS'!F:R,11,0),\"\")","v":44.04},null,{"$f":"+IFERROR(VLOOKUP(D108, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D108, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D108, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,58,null,{"$f":"+IFERROR(VLOOKUP(D109, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2029-09-02"},{"$f":"+IFERROR(VLOOKUP(D109, 'Simulador DATOS'!F:R,9,0),\"\")","v":1232.6999999999989},{"$f":"+IFERROR(VLOOKUP(D109, 'Simulador DATOS'!F:R,10,0),\"\")","v":399.77},null,{"$f":"+IFERROR(VLOOKUP(D109, 'Simulador DATOS'!F:R,11,0),\"\")","v":33.479999999999997},null,{"$f":"+IFERROR(VLOOKUP(D109, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D109, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D109, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,59,null,{"$f":"+IFERROR(VLOOKUP(D110, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2029-10-02"},{"$f":"+IFERROR(VLOOKUP(D110, 'Simulador DATOS'!F:R,9,0),\"\")","v":832.92999999999893},{"$f":"+IFERROR(VLOOKUP(D110, 'Simulador DATOS'!F:R,10,0),\"\")","v":411.37},null,{"$f":"+IFERROR(VLOOKUP(D110, 'Simulador DATOS'!F:R,11,0),\"\")","v":21.88},null,{"$f":"+IFERROR(VLOOKUP(D110, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D110, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D110, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.25}]
[null,null,null,60,null,{"$f":"+IFERROR(VLOOKUP(D111, 'Simulador DATOS'!F:R,6,0),\"\")","v":"2029-11-02"},{"$f":"+IFERROR(VLOOKUP(D111, 'Simulador DATOS'!F:R,9,0),\"\")","v":421.55999999999892},{"$f":"+IFERROR(VLOOKUP(D111, 'Simulador DATOS'!F:R,10,0),\"\")","v":421.55999999999892},null,{"$f":"+IFERROR(VLOOKUP(D111, 'Simulador DATOS'!F:R,11,0),\"\")","v":11.45},null,{"$f":"+IFERROR(VLOOKUP(D111, 'Simulador DATOS'!F:R,12,0),\"\")","v":0},null,{"$f":"+IFERROR(VLOOKUP(D111, 'Simulador DATOS'!F:S,14,0),\"\")","v":10},{"$f":"+IFERROR(VLOOKUP(D111, 'Simulador DATOS'!F:T,15,0),\"\")","v":443.00999999999891}]
[null,null,null,{"$f":"+IF(D111=\"\", \"\", IF((D111+1)>$G$15,\"\", D111+1))","v":""},null,{"$f":"+IFERROR(VLOOKUP(D112, 'Simulador DATOS'!F:R,6,0),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(D112, 'Simulador DATOS'!F:R,9,0),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(D112, 'Simulador DATOS'!F:R,10,0),\"\")","v":""},null,{"$f":"+IFERROR(VLOOKUP(D112, 'Simulador DATOS'!F:R,11,0),\"\")","v":""},null,{"$f":"+IFERROR(VLOOKUP(D112, 'Simulador DATOS'!F:R,12,0),\"\")","v":""},null,{"$f":"+IFERROR(VLOOKUP(D112, 'Simulador DATOS'!F:S,14,0),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(D112, 'Simulador DATOS'!F:T,15,0),\"\")","v":""}]
[null,null,null,{"$f":"+IF(D112=\"\", \"\", IF((D112+1)>$G$15,\"\", D112+1))","v":""},null,{"$f":"+IFERROR(VLOOKUP(D113, 'Simulador DATOS'!F:R,6,0),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(D113, 'Simulador DATOS'!F:R,9,0),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(D113, 'Simulador DATOS'!F:R,10,0),\"\")","v":""},null,{"$f":"+IFERROR(VLOOKUP(D113, 'Simulador DATOS'!F:R,11,0),\"\")","v":""},null,{"$f":"+IFERROR(VLOOKUP(D113, 'Simulador DATOS'!F:R,12,0),\"\")","v":""},null,{"$f":"+IFERROR(VLOOKUP(D113, 'Simulador DATOS'!F:S,14,0),\"\")","v":""},{"$f":"+IFERROR(VLOOKUP(D113, 'Simulador DATOS'!F:T,15,0),\"\")","v":""}]

{"sheet":"Simulador DATOS","index":2,"n_rows":140,"n_cols":30,"rows_kept":140,"cut":false,"hidden":true,"merged":[[3,11,3,15],[24,1,25,2],[133,10,133,17]]}
[null,null,null,null,null,null,null,null,null,null,{"$f":"+($C$19-$C$17)","v":40},null,null,{"$f":"+N8/SUM(M8:M128)","v":433.24859562358222}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(OFFSET($L$8, IF(F9=0, 0, 1), 0):L9)","v":30},null,null,{"$f":"+N9/SUM(M8:M128)","v":437.00935185248915}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"CRONOGRAMA EXTRACASH"]
[]
[null,"TC",3.8,null,null,"Cuota","Días","Mes","Año","EX/ORD","Vencimiento","Días reales","Factor","Saldo Capital","Amortización","Interés","Desgravamen","Pago","Comisión","Total Cuota","Tasación","Gastos Notariales","Gastos Registrales","Otros Gastos","Total",null,null,{"$f":"+IRR(AB7:AB128)","v":2.7649933149834993E-2},{"$f":"+(1+AB6)^(12)-1","v":0.38721053992530896}]
[null,"Importe Dolares",{"$f":"+IF(SIMULADOR_!G9=\"DÓLARES\",SIMULADOR_!G13,SIMULADOR_!G13/C6)","v":3216.3157894736842},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+MAX(N8:N128)","v":12910.1}]
[null,"Importe del pp:",{"$f":"+SIMULADOR_!G13+SIMULADOR_!G31","v":12799},null,1,{"$f":"+IF($C$19>K8,0,1+F7)","v":0},{"$f":"IF($F8=0,DAY(K8),IF($C$15>=$F8,$C$18,0))","v":2},{"$f":"IF($F8=0,MONTH(K8),IF($F8=1,MONTH($C$19),IF($C$15>=$F8,IF(H7=12,1,H7+1),0)))","v":11},{"$f":"IF($F8=0,YEAR(K8),IF($F8=1,YEAR($C$19),IF($C$15>=$F8,IF(H7=12,I7+1,I7),0)))","v":2024},{"$f":"IF($C$35=2,IF(IF(DAY(K8)<=15,IF(OR(MONTH(K8)=8,MONTH(K8)=1),1,0),IF(OR(MONTH(K8)=7,MONTH(K8)=12),1,0)),2,IF(OR(F8=\"\",F8=0),0,1)),IF(OR(F8=\"\",F8=0),0,1))","v":0},{"$f":"+DATE(YEAR(C17),MONTH(C17)+1,C18)","v":"2024-11-02"},{"$f":"+K8-C17","v":10},{"$f":"IF(OR(F8>$C$15, F8=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F8=0, 1, 0), 0):L8)))*J8","v":0},{"$f":"C8","v":12799},{"$f":"IF(AND(F8>0,F8<$C$15),R8-P8-Q8, IF(AND(F8>0,F8=$C$15), N8, -P8-Q8))","v":-111.1},{"$f":"ROUND(N8*((1+$C$12)^(L8/30)-1),2)","v":111.1},{"$f":"+N8*((1+$C$27)^(L8)-1)","v":0},{"$f":"ROUND(IF(AND(F8>0,F8<$C$15),OFFSET($N$8,IF(F8=0,1,0),0)/SUM($M$8:$M$204),IF(F8=$C$15,N8+P8+Q8,0)),2)*J8","v":0},{"$f":"+IF(OR(F8=0,F8>$C$15),0,IF(F8<=$C$15,$C$39,0))","v":0},{"$f":"IF(F8=0,0,O8+P8+Q8+S8)","v":0},null,null,null,null,null,null,{"$f":"IF(IF(F8=0,\"\",F8)>$C$15,\"\",IF(F8=0,\"\",F8))","v":""},{"$f":"IF(T8=0, \"\", -T8)","v":""}]
[null,null,null,null,2,{"$f":"+IF($C$19>K9,0,1+F8)","v":1},{"$f":"IF($F9=0,DAY(K9),IF($C$15>=$F9,$C$18,0))","v":2},{"$f":"IF($F9=0,MONTH(K9),IF($F9=1,MONTH($C$19),IF($C$15>=$F9,IF(H8=12,1,H8+1),0)))","v":12},2024,{"$f":"IF($C$35=2,IF(IF(DAY(K9)<=15,IF(OR(MONTH(K9)=8,MONTH(K9)=1),1,0),IF(OR(MONTH(K9)=7,MONTH(K9)=12),1,0)),2,IF(OR(F9=\"\",F9=0),0,1)),IF(OR(F9=\"\",F9=0),0,1))","v":1},{"$f":"+EDATE(K8,1)","v":"2024-12-02"},{"$f":"IF($C$15>=$F9,K9-K8,0)","v":30},{"$f":"IF(OR(F9>$C$15, F9=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F9=0, 1, 0), 0):L9)))*J9","v":0.96601809380987591},{"$f":"IF(N8-O8<0.000000001,0,N8-O8)","v":12910.1},{"$f":"IF(AND(F9>0,F9<$C$15),R9-P9-Q9, IF(AND(F9>0,F9=$C$15), N9, -P9-Q9))","v":94.12},{"$f":"ROUND(N9*((1+$C$12)^(L9/30)-1),2)","v":339.13},{"$f":"+N9*((1+$C$27)^(L9)-1)","v":0},{"$f":"ROUND(IF(AND(F9>0,F9<$C$15),OFFSET($N$8,IF(F9=0,1,0),0)/SUM($M$8:$M$204),IF(F9=$C$15,N9+P9+Q9,0)),2)*J9","v":433.25},{"$f":"+IF(OR(F9=0,F9>$C$15),0,IF(F9<=$C$15,$C$39,0))","v":10},{"$f":"IF(F9=0,0,O9+P9+Q9+S9)","v":443.25},{"$f":"IF($C$15>=$F8,-PMT($C$12,$C$15,$C$31,0),0)","v":0},{"$f":"IF($C$15>=$F8,-PMT($C$12,$C$15,$C$32,0),0)","v":0},{"$f":"IF($C$15>=$F8,-PMT($C$12,$C$15,$C$33,0),0)","v":0},0,{"$f":"T8+U9+V9+W9+X9","v":0},null,{"$f":"IF(IF(F9=0,\"\",F9)>$C$15,\"\",IF(F9=0,\"\",F9))","v":1},{"$f":"IF(T9=0, \"\", -T9)","v":-443.25}]
[null,"TCEA (Anual):",{"$f":"+AC6","v":0.38721053992530896},null,3,2,{"$f":"IF($F10=0,DAY(K10),IF($C$15>=$F10,$C$18,0))","v":2},1,2025,1,{"$f":"+EDATE(K9,1)","v":"2025-01-02"},{"$f":"IF($C$15>=$F10,K10-K9,0)","v":31},{"$f":"IF(OR(F10>$C$15, F10=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F10=0, 1, 0), 0):L10)))*J10","v":0.94047842740733312},{"$f":"IF(N9-O9<0.000000001,0,N9-O9)","v":12815.98},85.220000000000027,{"$f":"ROUND(N10*((1+$C$12)^(L10/30)-1),2)","v":348.03},0,433.25,10,443.25,0,0,0,0,443.25,null,2,-443.25]
[null,"TEA (Anual):",{"$f":"+SIMULADOR_!G17","v":0.36499999999999999},null,4,3,{"$f":"IF($F11=0,DAY(K11),IF($C$15>=$F11,$C$18,0))","v":2},2,2025,1,"2025-02-02",31,{"$f":"IF(OR(F11>$C$15, F11=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F11=0, 1, 0), 0):L11)))*J11","v":0.91561398082120316},{"$f":"IF(N10-O10<0.000000001,0,N10-O10)","v":12730.76},87.529999999999973,345.72,0,433.25,10,443.25,0,0,0,0,443.25,null,3,-443.25]
[null,"Tasa Préstamo (Mensual):",{"$f":"+(1+C11)^(0.0833333333333333)-1","v":2.6268630645152058E-2},null,4,4,2,3,2025,1,"2025-03-02",28,{"$f":"IF(OR(F12>$C$15, F12=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F12=0, 1, 0), 0):L12)))*J12","v":0.8937212784840276},12643.23,123.54000000000002,309.70999999999998,0,433.25,10,443.25,0,0,0,0,443.25,null,4,-443.25]
[null,"Tasa Préstamo (Diaria):",{"$f":"+(1+C12)^(0.0333333333333333)-1","v":8.6469148764134474E-4},null,6,5,2,4,2025,1,"2025-04-02",31,{"$f":"IF(OR(F13>$C$15, F13=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F13=0, 1, 0), 0):L13)))*J13","v":0.87009300127514511},12519.689999999999,93.259999999999991,339.99,0,433.25,10,443.25,0,0,0,0,443.25,null,5,-443.25]
[null,null,null,null,7,6,2,5,2025,1,"2025-05-02",30,{"$f":"IF(OR(F14>$C$15, F14=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F14=0, 1, 0), 0):L14)))*J14","v":0.84782188141926529},12426.429999999998,106.82,326.43,0,433.25,10,443.25,0,0,0,0,443.25,null,6,-443.25]
[null,"No. Cuotas:",{"$f":"+SIMULADOR_!G15","v":60},null,8,7,2,6,2025,1,"2025-06-02",31,{"$f":"IF(OR(F15>$C$15, F15=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F15=0, 1, 0), 0):L15)))*J15","v":0.82540709627292685},12319.609999999999,98.699999999999989,334.55,0,433.25,10,443.25,0,0,0,0,443.25,null,7,-443.25]
[null,"Periodo de Gracia",{"$f":"+SIMULADOR_!G23","v":0},null,9,8,2,7,2025,1,"2025-07-02",30,{"$f":"IF(OR(F16>$C$15, F16=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F16=0, 1, 0), 0):L16)))*J16","v":0.80427976810910118},12220.909999999998,112.22000000000003,321.02999999999997,0,433.25,10,443.25,0,0,0,0,443.25,null,8,-443.25]
[null,"Fecha de compra:",{"$f":"+SIMULADOR_!G11","v":"2024-10-23"},null,10,9,2,8,2025,1,"2025-08-02",31,{"$f":"IF(OR(F17>$C$15, F17=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F17=0, 1, 0), 0):L17)))*J17","v":0.78301615296209193},12108.689999999999,104.43,328.82,0,433.25,10,443.25,0,0,0,0,443.25,null,9,-443.25]
[null,"Fecha de pago:",{"$f":"+SIMULADOR_!G19","v":2},null,11,10,2,9,2025,1,"2025-09-02",31,{"$f":"IF(OR(F18>$C$15, F18=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F18=0, 1, 0), 0):L18)))*J18","v":0.7623147070341133},12004.259999999998,107.25999999999999,325.99,0,433.25,10,443.25,0,0,0,0,443.25,null,10,-443.25]
[null,"Fecha de pago 1 cuota:",{"$f":"+IF(C16=0,IF(VALUE(DATE(YEAR(C17),MONTH(C17)+1,C18)-C17)<30,DATE(YEAR(C17),MONTH(C17)+2,C18),DATE(YEAR(C17),MONTH(C17)+1,C18)),IF(VALUE(DATE(YEAR(C17),MONTH(C17)+1,C18)-C17)<30,DATE(YEAR(C17),MONTH(C17)+2+C16,C18),DATE(YEAR(C17),MONTH(C17)+1+C16,C18)))","v":"2024-12-02"},null,12,11,2,10,2025,1,"2025-10-02",30,{"$f":"IF(OR(F19>$C$15, F19=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F19=0, 1, 0), 0):L19)))*J19","v":0.74280230757408383},11896.999999999998,120.73000000000002,312.52,0,433.25,10,443.25,0,0,0,0,443.25,null,11,-443.25]
[null,{"$f":"+$C$19-$C$21","v":40},{"$f":"+DATE(YEAR(C17),MONTH(C17)+1,C18)","v":"2024-11-02"},null,13,12,2,11,2025,1,"2025-11-02",31,{"$f":"IF(OR(F20>$C$15, F20=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F20=0, 1, 0), 0):L20)))*J20","v":0.72316403862234857},11776.269999999999,113.44999999999999,319.8,0,433.25,10,443.25,0,0,0,0,443.25,null,12,-443.25]
[null,null,{"$f":"+C17+30*$C$16","v":"2024-10-23"},null,14,13,2,12,2025,1,"2025-12-02",30,{"$f":"IF(OR(F21>$C$15, F21=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F21=0, 1, 0), 0):L21)))*J21","v":0.70465374954288595},11662.819999999998,126.88,306.37,0,433.25,10,443.25,0,0,0,0,443.25,null,13,-443.25]
[null,"Plan de Protección","NO",null,15,14,2,1,2026,1,"2026-01-02",31,{"$f":"IF(OR(F22>$C$15, F22=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F22=0, 1, 0), 0):L22)))*J22","v":0.68602405532913746},11535.939999999999,119.98000000000002,313.27,0,433.25,10,443.25,0,0,0,0,443.25,null,14,-443.25]
[null,"Costo Anual:",null,null,16,15,2,2,2026,1,"2026-02-02",31,{"$f":"IF(OR(F23>$C$15, F23=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F23=0, 1, 0), 0):L23)))*J23","v":0.66788689451455563},11415.96,123.24000000000001,310.01,0,433.25,10,443.25,0,0,0,0,443.25,null,15,-443.25]
[null,"Costo Mensual:",{"$f":"+SIMULADOR_!G27","v":0},null,17,16,2,3,2026,1,"2026-03-02",28,{"$f":"IF(OR(F24>$C$15, F24=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F24=0, 1, 0), 0):L24)))*J24","v":0.65191744747379099},11292.72,156.62,276.63,0,433.25,10,443.25,0,0,0,0,443.25,null,16,-443.25]
[null,"*SÓLO MODIFICA EL SPEECH, NO MODIFICA EL CRONOGRAMA",null,null,18,17,2,4,2026,1,"2026-04-02",31,{"$f":"IF(OR(F25>$C$15, F25=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F25=0, 1, 0), 0):L25)))*J25","v":0.63468199998355557},11136.099999999999,130.83999999999997,302.41000000000003,0,433.25,10,443.25,0,0,0,0,443.25,null,17,-443.25]
[null,null,null,null,19,18,2,5,2026,1,"2026-05-02",30,{"$f":"IF(OR(F26>$C$15, F26=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F26=0, 1, 0), 0):L26)))*J26","v":0.61843651947596867},11005.259999999998,144.16000000000003,289.08999999999997,0,433.25,10,443.25,0,0,0,0,443.25,null,18,-443.25]
[null,"Costo Diario",{"$f":"+C24/30","v":0},null,20,19,2,6,2026,1,"2026-06-02",31,{"$f":"IF(OR(F27>$C$15, F27=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F27=0, 1, 0), 0):L27)))*J27","v":0.60208624353416584},{"$f":"IF(N26-O26<0.0000001,0,N26-O26)","v":10861.099999999999},138.31,294.94,0,433.25,10,{"$f":"IF(F27=0,0,O27+P27+Q27+S27)","v":443.25},0,0,0,0,443.25,null,19,{"$f":"IF(T27=0, \"\", -T27)","v":-443.25}]
[null,null,null,null,21,20,2,7,2026,1,"2026-07-02",30,{"$f":"IF(OR(F28>$C$15, F28=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F28=0, 1, 0), 0):L28)))*J28","v":0.58667509222772596},10722.789999999999,151.57999999999998,281.67,0,433.25,10,443.25,0,0,0,0,443.25,null,20,-443.25]
[null,"Tasa Préstamo (Mensual):",{"$f":"+C12+C24","v":2.6268630645152058E-2},null,22,21,2,8,2026,1,"2026-08-02",31,{"$f":"IF(OR(F29>$C$15, F29=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F29=0, 1, 0), 0):L29)))*J29","v":0.57116452753107128},10571.21,146.18,287.07,0,433.25,10,443.25,0,0,0,0,443.25,null,21,-443.25,null,{"$f":"+O27-N27","v":-10722.789999999999}]
[null,"Tasa Préstamo (Diaria):",{"$f":"+(1+C29)^(0.0333333333333333)-1","v":8.6469148764134474E-4},null,23,22,2,9,2026,1,"2026-09-02",31,{"$f":"IF(OR(F30>$C$15, F30=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F30=0, 1, 0), 0):L30)))*J30","v":0.55606403242897806},10425.029999999999,150.14999999999998,283.10000000000002,0,433.25,10,443.25,0,0,0,0,443.25,null,22,-443.25]
[null,null,null,null,24,23,2,10,2026,1,"2026-10-02",30,{"$f":"IF(OR(F31>$C$15, F31=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F31=0, 1, 0), 0):L31)))*J31","v":0.5418308772425553},10274.879999999999,163.33999999999997,269.91000000000003,0,433.25,10,443.25,0,0,0,0,443.25,null,23,-443.25]
[null,{"$f":"+IF(C16=0,IF(VALUE(DATE(YEAR(C17),MONTH(C17)+1,C18)-C17)<30,DATE(YEAR(C17),MONTH(C17)+2,C18),DATE(YEAR(C17),MONTH(C17)+1,C18)),DATE(YEAR(C17),MONTH(C17)+C16,C18))","v":"2024-12-02"},null,null,25,24,2,11,2026,1,"2026-11-02",31,{"$f":"IF(OR(F32>$C$15, F32=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F32=0, 1, 0), 0):L32)))*J32","v":0.52750590761719818},10111.539999999999,158.66000000000003,274.58999999999997,0,433.25,10,443.25,0,0,0,0,443.25,null,24,-443.25]
[null,null,null,null,26,25,2,12,2026,1,"2026-12-02",30,{"$f":"IF(OR(F33>$C$15, F33=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F33=0, 1, 0), 0):L33)))*J33","v":0.51400373339443128},9952.8799999999992,171.8,261.45,0,433.25,10,443.25,0,0,0,0,443.25,null,25,-443.25]
[null,null,null,null,27,26,2,1,2027,1,"2027-01-02",31,{"$f":"IF(OR(F34>$C$15, F34=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F34=0, 1, 0), 0):L34)))*J34","v":0.50041446010371915},9781.08,167.63,265.62,0,433.25,10,443.25,0,0,0,0,443.25,null,26,-443.25]
[null,"TIPO DE CUOTA",{"$f":"+IF(SIMULADOR_!G21=\"ORDINARIA\", 1,2)","v":1},null,28,27,2,2,2027,1,"2027-02-02",31,{"$f":"IF(OR(F35>$C$15, F35=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F35=0, 1, 0), 0):L35)))*J35","v":0.48718446114619157},9613.4500000000007,172.19,261.06,0,433.25,10,443.25,0,0,0,0,443.25,null,27,-443.25]
[null,null,null,null,29,28,2,3,2027,1,"2027-03-02",28,{"$f":"IF(OR(F36>$C$15, F36=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F36=0, 1, 0), 0):L36)))*J36","v":0.47553568271490904},9441.26,201.98,231.27,0,433.25,10,443.25,0,0,0,0,443.25,null,28,-443.25]
[null,"MONEDA",{"$f":"+SIMULADOR_!G9","v":"SOLES"},null,30,29,2,4,2027,1,"2027-04-02",31,{"$f":"IF(OR(F37>$C$15, F37=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F37=0, 1, 0), 0):L37)))*J37","v":0.46296343093529141},9239.2800000000007,182.35,250.9,0,433.25,10,443.25,0,0,0,0,443.25,null,29,-443.25]
[null,null,null,null,31,30,2,5,2027,1,"2027-05-02",30,{"$f":"IF(OR(F38>$C$15, F38=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F38=0, 1, 0), 0):L38)))*J38","v":0.45111330222015561},9056.93,195.34,237.91,0,433.25,10,443.25,0,0,0,0,443.25,null,30,-443.25]
[null,"COMISIÓN",{"$f":"+SIMULADOR_!G35","v":10},null,32,31,2,6,2027,1,"2027-06-02",31,{"$f":"IF(OR(F39>$C$15, F39=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F39=0, 1, 0), 0):L39)))*J39","v":0.43918673135954855},8861.59,192.6,240.65,0,433.25,10,443.25,null,null,null,null,null,null,31,-443.25]
[null,null,null,null,33,32,2,7,2027,1,"2027-07-02",30,{"$f":"IF(OR(F40>$C$15, F40=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F40=0, 1, 0), 0):L40)))*J40","v":0.42794519704208367},8668.99,205.53,227.72,0,433.25,10,443.25,null,null,null,null,null,null,32,-443.25]
[null,null,null,null,34,33,2,8,2027,1,"2027-08-02",31,{"$f":"IF(OR(F41>$C$15, F41=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F41=0, 1, 0), 0):L41)))*J41","v":0.4166311464657429},8463.4599999999991,203.42,229.83,0,433.25,10,443.25,null,null,null,null,null,null,33,-443.25]
[null,"Filtro ",{"$f":"+C7","v":3216.3157894736842},null,35,34,2,9,2027,1,"2027-09-02",31,{"$f":"IF(OR(F42>$C$15, F42=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F42=0, 1, 0), 0):L42)))*J42","v":0.40561621769595319},8260.0399999999991,208.94,224.31,0,433.25,10,443.25,null,null,null,null,null,null,34,-443.25]
[null,null,null,null,36,35,2,10,2027,1,"2027-10-02",30,{"$f":"IF(OR(F43>$C$15, F43=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F43=0, 1, 0), 0):L43)))*J43","v":0.39523396271107641},8051.0999999999995,221.76,211.49,0,433.25,10,443.25,null,null,null,null,null,null,35,-443.25]
[null,null,null,null,37,36,2,11,2027,1,"2027-11-02",31,{"$f":"IF(OR(F44>$C$15, F44=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F44=0, 1, 0), 0):L44)))*J44","v":0.38478473445823336},7829.3399999999992,220.64,212.61,0,433.25,10,443.25,null,null,null,null,null,null,36,-443.25]
[null,null,null,null,38,37,2,12,2027,1,"2027-12-02",30,{"$f":"IF(OR(F45>$C$15, F45=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F45=0, 1, 0), 0):L45)))*J45","v":0.37493568737099864},7608.6999999999989,233.38,199.87,0,433.25,10,443.25,null,null,null,null,null,null,37,-443.25]
[null,null,null,null,39,38,2,1,2028,1,"2028-01-02",31,{"$f":"IF(OR(F46>$C$15, F46=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F46=0, 1, 0), 0):L46)))*J46","v":0.36502310660338855},7375.3199999999988,232.97,200.28,0,433.25,10,443.25,null,null,null,null,null,null,38,-443.25]
[null,null,null,null,40,39,2,2,2028,1,"2028-02-02",31,{"$f":"IF(OR(F47>$C$15, F47=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F47=0, 1, 0), 0):L47)))*J47","v":0.35537259546740857},7142.3499999999985,239.29,193.96,0,433.25,10,443.25,null,null,null,null,null,null,39,-443.25]
[null,null,null,null,41,40,2,3,2028,1,"2028-03-02",29,{"$f":"IF(OR(F48>$C$15, F48=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F48=0, 1, 0), 0):L48)))*J48","v":0.3465758111519559},6903.0599999999986,258.03999999999996,175.21,0,433.25,10,443.25,null,null,null,null,null,null,40,-443.25]
[null,null,null,null,42,41,2,4,2028,1,"2028-04-02",31,{"$f":"IF(OR(F49>$C$15, F49=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F49=0, 1, 0), 0):L49)))*J49","v":0.33741301114155209},6645.0199999999986,252.8,180.45,0,433.25,10,443.25,null,null,null,null,null,null,41,-443.25]
[null,null,null,null,43,42,2,5,2028,1,"2028-05-02",30,{"$f":"IF(OR(F50>$C$15, F50=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F50=0, 1, 0), 0):L50)))*J50","v":0.32877650262918151},6392.2199999999984,265.34000000000003,167.91,0,433.25,10,443.25,null,null,null,null,null,null,42,-443.25]
[null,null,null,null,44,43,2,6,2028,1,"2028-06-02",31,{"$f":"IF(OR(F51>$C$15, F51=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F51=0, 1, 0), 0):L51)))*J51","v":0.32008428221224539},6126.8799999999983,266.87,166.38,0,433.25,10,443.25,null,null,null,null,null,null,43,-443.25]
[null,null,null,null,45,44,2,7,2028,1,"2028-07-02",30,{"$f":"IF(OR(F52>$C$15, F52=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F52=0, 1, 0), 0):L52)))*J52","v":0.31189132421501414},5860.0099999999984,279.32,153.93,0,433.25,10,443.25,null,null,null,null,null,null,44,-443.25]
[null,null,null,null,46,45,2,8,2028,1,"2028-08-02",31,{"$f":"IF(OR(F53>$C$15, F53=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F53=0, 1, 0), 0):L53)))*J53","v":0.30364551554399516},5580.6899999999987,281.7,151.55000000000001,0,433.25,10,443.25,null,null,null,null,null,null,45,-443.25]
[null,null,null,null,47,46,2,9,2028,1,"2028-09-02",31,{"$f":"IF(OR(F54>$C$15, F54=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F54=0, 1, 0), 0):L54)))*J54","v":0.29561771024581829},5298.9899999999989,289.35000000000002,143.9,0,433.25,10,443.25,null,null,null,null,null,null,46,-443.25]
[null,null,null,null,48,47,2,10,2028,1,"2028-10-02",30,{"$f":"IF(OR(F55>$C$15, F55=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F55=0, 1, 0), 0):L55)))*J55","v":0.28805100479392209},5009.6399999999985,301.64999999999998,131.6,0,433.25,10,443.25,null,null,null,null,null,null,47,-443.25]
[null,null,null,null,49,48,2,11,2028,1,"2028-11-02",31,{"$f":"IF(OR(F56>$C$15, F56=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F56=0, 1, 0), 0):L56)))*J56","v":0.28043548846302208},4707.9899999999989,305.39999999999998,127.85,0,433.25,10,443.25,null,null,null,null,null,null,48,-443.25]
[null,null,null,null,50,49,2,12,2028,1,"2028-12-02",30,{"$f":"IF(OR(F57>$C$15, F57=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F57=0, 1, 0), 0):L57)))*J57","v":0.27325739098809815},4402.5899999999992,317.60000000000002,115.65,0,433.25,10,443.25,null,null,null,null,null,null,49,-443.25]
[null,null,null,null,51,50,2,1,2029,1,"2029-01-02",31,{"$f":"IF(OR(F58>$C$15, F58=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F58=0, 1, 0), 0):L58)))*J58","v":0.26603298944470571},4084.9899999999993,322.32,110.93,0,433.25,10,443.25,null,null,null,null,null,null,50,-443.25]
[null,null,null,null,52,51,2,2,2029,1,"2029-02-02",31,{"$f":"IF(OR(F59>$C$15, F59=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F59=0, 1, 0), 0):L59)))*J59","v":0.25899958722788746},3762.6699999999992,331.07,102.18,0,433.25,10,443.25,null,null,null,null,null,null,51,-443.25]
[null,null,null,null,53,52,2,3,2029,1,"2029-03-02",28,{"$f":"IF(OR(F60>$C$15, F60=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F60=0, 1, 0), 0):L60)))*J60","v":0.25280680185391796},3431.599999999999,349.19,84.06,0,433.25,10,443.25,null,null,null,null,null,null,52,-443.25]
[null,null,null,null,54,53,2,4,2029,1,"2029-04-02",31,{"$f":"IF(OR(F61>$C$15, F61=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F61=0, 1, 0), 0):L61)))*J61","v":0.24612307468046671},3082.4099999999989,349.54,83.71,0,433.25,10,443.25,null,null,null,null,null,null,53,-443.25]
[null,null,null,null,55,54,2,5,2029,1,"2029-05-02",30,{"$f":"IF(OR(F62>$C$15, F62=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F62=0, 1, 0), 0):L62)))*J62","v":0.23982324640064701},2732.869999999999,361.46,71.790000000000006,0,433.25,10,443.25,null,null,null,null,null,null,54,-443.25]
[null,null,null,null,56,55,2,6,2029,1,"2029-06-02",31,{"$f":"IF(OR(F63>$C$15, F63=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F63=0, 1, 0), 0):L63)))*J63","v":0.23348277954200791},2371.4099999999989,368.85,64.400000000000006,0,433.25,10,443.25,null,null,null,null,null,null,55,-443.25]
[null,null,null,null,57,56,2,7,2029,1,"2029-07-02",30,{"$f":"IF(OR(F64>$C$15, F64=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F64=0, 1, 0), 0):L64)))*J64","v":0.22750649544382137},2002.559999999999,380.65,52.6,0,433.25,10,443.25,null,null,null,null,null,null,56,-443.25]
[null,null,null,null,58,57,2,8,2029,1,"2029-08-02",31,{"$f":"IF(OR(F65>$C$15, F65=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F65=0, 1, 0), 0):L65)))*J65","v":0.22149165986747002},1621.9099999999989,389.21,44.04,0,433.25,10,443.25,null,null,null,null,null,null,57,-443.25]
[null,null,null,null,59,58,2,9,2029,1,"2029-09-02",31,{"$f":"IF(OR(F66>$C$15, F66=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F66=0, 1, 0), 0):L66)))*J66","v":0.21563584501243899},1232.6999999999989,399.77,33.479999999999997,0,433.25,10,443.25,null,null,null,null,null,null,58,-443.25]
[null,null,null,null,60,59,2,10,2029,1,"2029-10-02",30,{"$f":"IF(OR(F67>$C$15, F67=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F67=0, 1, 0), 0):L67)))*J67","v":0.21011637555060245},832.92999999999893,411.37,21.88,0,433.25,10,443.25,null,null,null,null,null,null,59,-443.25]
[null,null,null,null,61,60,2,11,2029,1,"2029-11-02",31,{"$f":"IF(OR(F68>$C$15, F68=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F68=0, 1, 0), 0):L68)))*J68","v":0.20456130140482781},421.55999999999892,421.55999999999892,11.45,0,433.01,10,443.00999999999891,null,null,null,null,null,null,60,-443.00999999999891]
[null,null,null,null,62,61,0,0,0,1,"2029-12-02",0,{"$f":"IF(OR(F69>$C$15, F69=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F69=0, 1, 0), 0):L69)))*J69","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,63,62,0,0,0,1,"2030-01-02",0,{"$f":"IF(OR(F70>$C$15, F70=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F70=0, 1, 0), 0):L70)))*J70","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,64,63,0,0,0,1,"2030-02-02",0,{"$f":"IF(OR(F71>$C$15, F71=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F71=0, 1, 0), 0):L71)))*J71","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,65,64,0,{"$f":"IF($F72=0,MONTH(K72),IF($F72=1,MONTH($C$19),IF($C$15>=$F72,IF(H71=12,1,H71+1),0)))","v":0},{"$f":"IF($F72=0,YEAR(K72),IF($F72=1,YEAR($C$19),IF($C$15>=$F72,IF(H71=12,I71+1,I71),0)))","v":0},1,"2030-03-02",0,{"$f":"IF(OR(F72>$C$15, F72=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F72=0, 1, 0), 0):L72)))*J72","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,66,{"$f":"+IF($C$19>K73,0,1+F72)","v":65},0,0,0,{"$f":"IF($C$35=2,IF(IF(DAY(K73)<=15,IF(OR(MONTH(K73)=8,MONTH(K73)=1),1,0),IF(OR(MONTH(K73)=7,MONTH(K73)=12),1,0)),2,IF(OR(F73=\"\",F73=0),0,1)),IF(OR(F73=\"\",F73=0),0,1))","v":1},"2030-04-02",0,{"$f":"IF(OR(F73>$C$15, F73=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F73=0, 1, 0), 0):L73)))*J73","v":0},0,{"$f":"IF(AND(F73>0,F73<$C$15),R73-P73-Q73, IF(AND(F73>0,F73=$C$15), N73, -P73-Q73))","v":0},{"$f":"ROUND(N73*((1+$C$12)^(L73/30)-1),2)","v":0},{"$f":"+N73*((1+$C$27)^(L73)-1)","v":0},{"$f":"ROUND(IF(AND(F73>0,F73<$C$15),OFFSET($N$8,IF(F73=0,1,0),0)/SUM($M$8:$M$204),IF(F73=$C$15,N73+P73+Q73,0)),2)*J73","v":0},{"$f":"+IF(OR(F73=0,F73>$C$15),0,IF(F73<=$C$15,$C$39,0))","v":0},{"$f":"IF(F73=0,0,O73+P73+Q73+S73)","v":0},null,null,null,null,null,null,{"$f":"IF(IF(F73=0,\"\",F73)>$C$15,\"\",IF(F73=0,\"\",F73))","v":""},{"$f":"IF(T73=0, \"\", -T73)","v":""}]
[null,null,null,null,67,66,0,0,0,1,{"$f":"+EDATE(K73,1)","v":"2030-05-02"},{"$f":"IF($C$15>=$F74,K74-K73,0)","v":0},{"$f":"IF(OR(F74>$C$15, F74=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F74=0, 1, 0), 0):L74)))*J74","v":0},{"$f":"IF(N73-O73<0.000000001,0,N73-O73)","v":0},0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,68,67,{"$f":"IF($F75=0,DAY(K75),IF($C$15>=$F75,$C$18,0))","v":0},0,0,1,"2030-06-02",0,{"$f":"IF(OR(F75>$C$15, F75=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F75=0, 1, 0), 0):L75)))*J75","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,69,68,0,0,0,1,"2030-07-02",0,{"$f":"IF(OR(F76>$C$15, F76=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F76=0, 1, 0), 0):L76)))*J76","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,70,69,0,0,0,1,"2030-08-02",0,{"$f":"IF(OR(F77>$C$15, F77=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F77=0, 1, 0), 0):L77)))*J77","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,71,70,0,0,0,1,"2030-09-02",0,{"$f":"IF(OR(F78>$C$15, F78=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F78=0, 1, 0), 0):L78)))*J78","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,72,71,0,0,0,1,"2030-10-02",0,{"$f":"IF(OR(F79>$C$15, F79=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F79=0, 1, 0), 0):L79)))*J79","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,73,72,0,0,0,1,"2030-11-02",0,{"$f":"IF(OR(F80>$C$15, F80=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F80=0, 1, 0), 0):L80)))*J80","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,74,73,0,0,0,1,"2030-12-02",0,{"$f":"IF(OR(F81>$C$15, F81=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F81=0, 1, 0), 0):L81)))*J81","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,75,74,0,0,0,1,"2031-01-02",0,{"$f":"IF(OR(F82>$C$15, F82=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F82=0, 1, 0), 0):L82)))*J82","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,76,75,0,0,0,1,"2031-02-02",0,{"$f":"IF(OR(F83>$C$15, F83=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F83=0, 1, 0), 0):L83)))*J83","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,77,76,0,0,0,1,"2031-03-02",0,{"$f":"IF(OR(F84>$C$15, F84=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F84=0, 1, 0), 0):L84)))*J84","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,78,77,0,0,0,1,"2031-04-02",0,{"$f":"IF(OR(F85>$C$15, F85=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F85=0, 1, 0), 0):L85)))*J85","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,79,78,0,0,0,1,"2031-05-02",0,{"$f":"IF(OR(F86>$C$15, F86=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F86=0, 1, 0), 0):L86)))*J86","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,80,79,0,0,0,1,"2031-06-02",0,{"$f":"IF(OR(F87>$C$15, F87=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F87=0, 1, 0), 0):L87)))*J87","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,81,80,0,0,0,1,"2031-07-02",0,{"$f":"IF(OR(F88>$C$15, F88=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F88=0, 1, 0), 0):L88)))*J88","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,82,81,0,0,0,1,"2031-08-02",0,{"$f":"IF(OR(F89>$C$15, F89=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F89=0, 1, 0), 0):L89)))*J89","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,83,82,0,0,0,1,"2031-09-02",0,{"$f":"IF(OR(F90>$C$15, F90=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F90=0, 1, 0), 0):L90)))*J90","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,84,83,0,0,0,1,"2031-10-02",0,{"$f":"IF(OR(F91>$C$15, F91=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F91=0, 1, 0), 0):L91)))*J91","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,85,84,0,0,0,1,"2031-11-02",0,{"$f":"IF(OR(F92>$C$15, F92=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F92=0, 1, 0), 0):L92)))*J92","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,86,85,0,0,0,1,"2031-12-02",0,{"$f":"IF(OR(F93>$C$15, F93=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F93=0, 1, 0), 0):L93)))*J93","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,87,86,0,0,0,1,"2032-01-02",0,{"$f":"IF(OR(F94>$C$15, F94=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F94=0, 1, 0), 0):L94)))*J94","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,88,87,0,0,0,1,"2032-02-02",0,{"$f":"IF(OR(F95>$C$15, F95=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F95=0, 1, 0), 0):L95)))*J95","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,89,88,0,0,0,1,"2032-03-02",0,{"$f":"IF(OR(F96>$C$15, F96=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F96=0, 1, 0), 0):L96)))*J96","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,90,89,0,0,0,1,"2032-04-02",0,{"$f":"IF(OR(F97>$C$15, F97=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F97=0, 1, 0), 0):L97)))*J97","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,91,90,0,0,0,1,"2032-05-02",0,{"$f":"IF(OR(F98>$C$15, F98=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F98=0, 1, 0), 0):L98)))*J98","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,92,91,0,0,0,1,"2032-06-02",0,{"$f":"IF(OR(F99>$C$15, F99=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F99=0, 1, 0), 0):L99)))*J99","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,93,92,0,0,0,1,"2032-07-02",0,{"$f":"IF(OR(F100>$C$15, F100=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F100=0, 1, 0), 0):L100)))*J100","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,94,93,0,0,0,1,"2032-08-02",0,{"$f":"IF(OR(F101>$C$15, F101=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F101=0, 1, 0), 0):L101)))*J101","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,95,94,0,0,0,1,"2032-09-02",0,{"$f":"IF(OR(F102>$C$15, F102=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F102=0, 1, 0), 0):L102)))*J102","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,96,95,0,0,0,1,"2032-10-02",0,{"$f":"IF(OR(F103>$C$15, F103=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F103=0, 1, 0), 0):L103)))*J103","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,97,96,0,0,0,1,"2032-11-02",0,{"$f":"IF(OR(F104>$C$15, F104=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F104=0, 1, 0), 0):L104)))*J104","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,98,97,0,0,0,1,"2032-12-02",0,{"$f":"IF(OR(F105>$C$15, F105=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F105=0, 1, 0), 0):L105)))*J105","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,99,98,0,0,0,1,"2033-01-02",0,{"$f":"IF(OR(F106>$C$15, F106=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F106=0, 1, 0), 0):L106)))*J106","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,100,99,0,0,0,1,"2033-02-02",0,{"$f":"IF(OR(F107>$C$15, F107=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F107=0, 1, 0), 0):L107)))*J107","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,101,100,0,0,0,1,"2033-03-02",0,{"$f":"IF(OR(F108>$C$15, F108=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F108=0, 1, 0), 0):L108)))*J108","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,102,101,0,0,0,1,"2033-04-02",0,{"$f":"IF(OR(F109>$C$15, F109=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F109=0, 1, 0), 0):L109)))*J109","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,103,102,0,0,0,1,"2033-05-02",0,{"$f":"IF(OR(F110>$C$15, F110=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F110=0, 1, 0), 0):L110)))*J110","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,104,103,0,0,0,1,"2033-06-02",0,{"$f":"IF(OR(F111>$C$15, F111=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F111=0, 1, 0), 0):L111)))*J111","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,105,104,0,0,0,1,"2033-07-02",0,{"$f":"IF(OR(F112>$C$15, F112=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F112=0, 1, 0), 0):L112)))*J112","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,106,105,0,0,0,1,"2033-08-02",0,{"$f":"IF(OR(F113>$C$15, F113=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F113=0, 1, 0), 0):L113)))*J113","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,107,106,0,0,0,1,"2033-09-02",0,{"$f":"IF(OR(F114>$C$15, F114=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F114=0, 1, 0), 0):L114)))*J114","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,108,107,0,0,0,1,"2033-10-02",0,{"$f":"IF(OR(F115>$C$15, F115=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F115=0, 1, 0), 0):L115)))*J115","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,109,108,0,0,0,1,"2033-11-02",0,{"$f":"IF(OR(F116>$C$15, F116=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F116=0, 1, 0), 0):L116)))*J116","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,110,109,0,0,0,1,"2033-12-02",0,{"$f":"IF(OR(F117>$C$15, F117=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F117=0, 1, 0), 0):L117)))*J117","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,111,110,0,0,0,1,"2034-01-02",0,{"$f":"IF(OR(F118>$C$15, F118=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F118=0, 1, 0), 0):L118)))*J118","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,112,111,0,0,0,1,"2034-02-02",0,{"$f":"IF(OR(F119>$C$15, F119=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F119=0, 1, 0), 0):L119)))*J119","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,113,112,0,0,0,1,"2034-03-02",0,{"$f":"IF(OR(F120>$C$15, F120=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F120=0, 1, 0), 0):L120)))*J120","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,114,113,0,0,0,1,"2034-04-02",0,{"$f":"IF(OR(F121>$C$15, F121=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F121=0, 1, 0), 0):L121)))*J121","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,115,114,0,0,0,1,"2034-05-02",0,{"$f":"IF(OR(F122>$C$15, F122=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F122=0, 1, 0), 0):L122)))*J122","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,116,115,0,0,0,1,"2034-06-02",0,{"$f":"IF(OR(F123>$C$15, F123=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F123=0, 1, 0), 0):L123)))*J123","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,117,116,0,0,0,1,"2034-07-02",0,{"$f":"IF(OR(F124>$C$15, F124=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F124=0, 1, 0), 0):L124)))*J124","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,118,117,0,0,0,1,"2034-08-02",0,{"$f":"IF(OR(F125>$C$15, F125=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F125=0, 1, 0), 0):L125)))*J125","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,119,118,0,0,0,1,"2034-09-02",0,{"$f":"IF(OR(F126>$C$15, F126=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F126=0, 1, 0), 0):L126)))*J126","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,120,119,0,0,0,1,"2034-10-02",0,{"$f":"IF(OR(F127>$C$15, F127=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F127=0, 1, 0), 0):L127)))*J127","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[null,null,null,null,121,120,0,0,0,1,"2034-11-02",0,{"$f":"IF(OR(F128>$C$15, F128=0),0, 1*(1/(1+$C$30)^SUM(OFFSET($L$8, IF(F128=0, 1, 0), 0):L128)))*J128","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"",""]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"RESUMEN EXTRACASH"]
[null,null,null,null,null,null,null,null,null,null,"MONTO DE CREDITO",null,null,null,null,null,null,{"$f":"C8","v":12799}]
[null,null,null,null,null,null,null,null,null,null,"EFECTIVA ANUAL FIJA",null,null,null,null,null,null,{"$f":"C11","v":0.36499999999999999}]
[null,null,null,null,null,null,null,null,null,null,"TASA DE COSTO EFECTIVO ANUAL"]
[null,null,null,null,null,null,null,null,null,null,"NRO CUOTAS MENSUALES",null,null,null,null,null,null,{"$f":"C15","v":60}]
[null,null,null,null,null,null,null,null,null,null,"MONEDA",null,null,null,null,null,null,"SOLES"]
[null,null,null,null,null,null,null,null,null,null,"FECHA DE PAGO PRIMERA CUOTA",null,null,null,null,null,null,{"$f":"C19","v":"2024-12-02"}]

{"sheet":"Hoja1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"LEYENDA","index":4,"n_rows":66,"n_cols":19,"rows_kept":66,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"SIN DEVOLUC.","SIN DEVOLUC.","SIN SEGURO (ENDOSO)",null,null,"TARIFA DE PROTECCIÓN FINANCIERA Soles","Soles",null,"Dolares"]
[null,"SIN SEGURO (ENDOSO)","CON DEVOLUC.",null,null,null,1,73,null,34]
[null,null,"SIN SEGURO (ENDOSO)",null,null,null,2,73,null,34,null,null,null,null,null,{"$f":"+Q6&R6","v":"SOLESFÍSICO - CON PLANILLA"},"SOLES","FÍSICO - CON PLANILLA",4]
[null,null,null,null,null,null,3,73,null,34,null,null,null,null,null,{"$f":"+Q7&R7","v":"SOLESFÍSICO - SIN PLANILLA"},"SOLES","FÍSICO - SIN PLANILLA",10]
[null,null,null,null,null,null,4,73,null,34,null,null,null,null,null,"SOLESVIRTUAL","SOLES","VIRTUAL",0]
[null,null,"SÍ",null,null,null,5,73,null,34,null,null,null,null,null,"DÓLARESFÍSICO - CON PLANILLA","DÓLARES","FÍSICO - CON PLANILLA",1.5]
[null,null,"NO",null,null,null,6,73,null,34,null,null,null,null,null,"DÓLARESFÍSICO - SIN PLANILLA","DÓLARES","FÍSICO - SIN PLANILLA",3.5]
[null,null,null,null,null,null,7,110,null,51,null,null,null,null,null,"DÓLARESVIRTUAL","DÓLARES","VIRTUAL",0]
[null,null,null,null,null,null,8,110,null,51]
[null,null,null,null,null,null,9,110,null,51]
[null,null,"FÍSICO - CON PLANILLA",null,null,null,10,145,145,68]
[null,null,"FÍSICO - SIN PLANILLA",null,null,null,11,145,185,68]
[null,null,"VIRTUAL",null,null,null,12,145,252,68]
[null,null,null,null,null,null,13,185,369,88]
[null,null,null,null,null,null,14,185,454,88]
[null,null,0,null,null,null,15,185,577,88]
[null,null,1,null,null,null,16,185,null,88]
[null,null,2,null,null,null,17,185,null,88]
[null,null,null,null,null,null,18,185,null,88]
[null,null,2,null,null,null,19,252,null,120]
[null,null,17,null,null,null,20,252,null,120]
[null,null,null,null,null,null,21,252,null,120]
[null,null,null,null,null,null,22,252,null,120,null,null,null,null,null,null,577]
[null,null,"SOLES",null,null,null,23,252,null,120,null,null,null,null,null,null,236,{"$f":"+Q26/Q27","v":2.4449152542372881}]
[null,null,"DÓLARES",null,null,null,24,252,null,120,null,null,null,null,null,null,{"$f":"+Q26/3.75","v":153.86666666666667}]
[null,null,null,null,null,null,25,369,null,186]
[null,null,null,null,null,null,26,369,null,186]
[null,null,null,null,null,null,27,369,null,186]
[null,null,"ORDINARIA",null,null,null,28,369,null,186]
[null,null,"EXTRAORDINARIA",null,null,null,29,369,null,186]
[null,null,null,null,null,null,30,369,null,186]
[null,null,null,null,null,null,31,369,null,186]
[null,null,null,null,null,null,32,369,null,186]
[null,null,null,null,null,null,33,369,null,186]
[null,null,null,null,null,null,34,369,null,186]
[null,null,null,null,null,null,35,369,null,186]
[null,null,null,null,null,null,36,369,null,186]
[null,null,null,null,null,null,37,454,null,186]
[null,null,null,null,null,null,38,454,null,186]
[null,null,null,null,null,null,39,454,null,186]
[null,null,null,null,null,null,40,454,null,186]
[null,null,null,null,null,null,41,454,null,186]
[null,null,null,null,null,null,42,454,null,186]
[null,null,null,null,null,null,43,454,null,186]
[null,null,null,null,null,null,44,454,null,186]
[null,null,null,null,null,null,45,454,null,186]
[null,null,null,null,null,null,46,454,null,186]
[null,{"$f":"+IF('Simulador DATOS'!$C$42>300000,LEYENDA!$D$4,IF(SIMULADOR_!$G$15>23,LEYENDA!$C$4:$C$6,LEYENDA!$B$4:$B$5))","v":"SIN DEVOLUC."},null,null,null,null,47,454,null,186]
[null,"CON DEVOLUC.",null,null,null,null,48,454,null,186]
[null,"SIN SEGURO (ENDOSO)",null,null,null,null,49,577,null,236]
[null,null,null,null,null,null,50,577,null,236]
[null,null,null,null,null,null,51,577,null,236]
[null,null,null,null,null,null,52,577,null,236]
[null,null,null,null,null,null,53,577,null,236]
[null,null,null,null,null,null,54,577,null,236]
[null,null,null,null,null,null,55,577,null,236]
[null,null,null,null,null,null,56,577,null,236]
[null,null,null,null,null,null,57,577,null,236]
[null,null,null,null,null,null,58,577,null,236]
[null,null,null,null,null,null,59,577,null,236]
[null,null,null,null,null,null,60,577,null,236]
[null,null,null,null,null,null,61,577,null,236]
[null,null,null,null,null,null,62,577,null,236]